Re: why cannot UNION both SELECT and SHOW?

From: Rodrigo Gonzalez <rjgonzale(at)estrads(dot)com(dot)ar>
To: Konstantin Izmailov <pgfizm(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: why cannot UNION both SELECT and SHOW?
Date: 2011-08-01 21:12:51
Message-ID: 4E3716D3.3000701@estrads.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Reuven M. Lerner 2011-08-01 21:12:58 Re: Pending trigger events on ALTER TABLE in 8.3
Previous Message Adrian Klaver 2011-08-01 21:12:50 Re: why cannot UNION both SELECT and SHOW?