Postgres Pro
Downloads
Home   >   mailing lists

why cannot UNION both SELECT and SHOW? - Mailing list pgsql-general

From Konstantin Izmailov
Subject why cannot UNION both SELECT and SHOW?
Date
Msg-id CAAw-MscSWBuDWh1cRhXGA6ZnYM2vep_RN9gTM2ffib__YKHTPg@mail.gmail.com
Whole thread Raw
Responses Re: why cannot UNION both SELECT and SHOW?
Re: why cannot UNION both SELECT and SHOW?
Re: why cannot UNION both SELECT and SHOW?
List pgsql-general
Tree view
Is it possible instead of executing following two statements:
  SHOW search_path; SELECT version();
to execute just one statement returning both search_path and version?

I'm using Postgres 9.0 and need the result either as two tuples or two fields...

Could you suggest how to rewrite the two statements?

Thx

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: string comparison problem
Next
From: kleptog@svana.org
Date:
Subject: Re: string comparison problem