why cannot UNION both SELECT and SHOW?

Поиск
Список
Период
Сортировка
От Konstantin Izmailov
Тема why cannot UNION both SELECT and SHOW?
Дата
Msg-id CAAw-MscSWBuDWh1cRhXGA6ZnYM2vep_RN9gTM2ffib__YKHTPg@mail.gmail.com
обсуждение исходный текст
Ответы Re: why cannot UNION both SELECT and SHOW?  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: why cannot UNION both SELECT and SHOW?  (Jerry Sievers <gsievers19@comcast.net>)
Re: why cannot UNION both SELECT and SHOW?  (Rodrigo Gonzalez <rjgonzale@estrads.com.ar>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: string comparison problem
Следующее
От: kleptog@svana.org
Дата:
Сообщение: Re: string comparison problem