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

From Rodrigo Gonzalez
Subject Re: why cannot UNION both SELECT and SHOW?
Date
Msg-id 4E3716D3.3000701@estrads.com.ar
Whole thread Raw
In response to why cannot UNION both SELECT and SHOW?  (Konstantin Izmailov <pgfizm@gmail.com>)
List pgsql-general
select current_setting('search_path') union select version();

Regards

Rodrigo

On 08/01/2011 06:07 PM, Konstantin Izmailov wrote:
> 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: Jerry Sievers
Date:
Subject: Re: why cannot UNION both SELECT and SHOW?
Next
From: Tom Lane
Date:
Subject: Re: Pending trigger events on ALTER TABLE in 8.3