why cannot UNION both SELECT and SHOW?

From: Konstantin Izmailov <pgfizm(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: why cannot UNION both SELECT and SHOW?
Date: 2011-08-01 21:07:04
Message-ID: CAAw-MscSWBuDWh1cRhXGA6ZnYM2vep_RN9gTM2ffib__YKHTPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2011-08-01 21:12:50 Re: why cannot UNION both SELECT and SHOW?
Previous Message kleptog 2011-08-01 21:02:16 Re: string comparison problem