Re: why cannot UNION both SELECT and SHOW?

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