Re: [GENERAL] column names query
От
hamann.w@t-online.de
Тема
Re: [GENERAL] column names query
Дата
Msg-id
wolfgang-1170908081620.A0530521@noten19.local
Ответ на
Re: [GENERAL] column names query (Manuel Gómez)
Список
Дерево обсуждения
[GENERAL] column names query hamann.w@t-online.de
Re: [GENERAL] column names query stimits@comcast.net
Re: [GENERAL] column names query hamann.w@t-online.de
Re: [GENERAL] column names query Manuel Gómez <targen@gmail.com>
Re: [GENERAL] column names query hamann.w@t-online.de
Re: [GENERAL] column names query Francisco Olarte <folarte@peoplecall.com>
Re: [GENERAL] column names query hamann.w@t-online.de
Re: [GENERAL] column names query Francisco Olarte <folarte@peoplecall.com>
Re: [GENERAL] column names query John R Pierce <pierce@hogranch.com>
>> On Thu, Sep 7, 2017 at 3:28 PM wrote: >> >> > Example query >> > select a.col1, case when a.col2 > 0 then a.col3 else b.xcol1 end as mycol3 >> > from a left join b on .... >> > Expected response >> > col1 mycol3 >> > >> >> This may be overkill, but works: >> >> postgres=# \copy (select 1 as foo, 2 as bar limit 0) to stdout with (format >> csv, header, delimiter ' ') >> foo bar >> Hi Manuel, this works perfectly, many thanks Wolfgang -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления
От: Craig Ringer
Дата:
