Re: "Concatenate" two queries - how?

Поиск
Список
Период
Сортировка
От Harald Fuchs
Тема Re: "Concatenate" two queries - how?
Дата
Msg-id pu7ilcz3ym.fsf@srv.protecting.net
обсуждение исходный текст
Ответ на "Concatenate" two queries - how?  (Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>)
Список pgsql-general
In article <20071024132516.GI19546@a-kretschmer.de>,
"A. Kretschmer" <andreas.kretschmer@schollglas.com> writes:

> am  Wed, dem 24.10.2007, um 15:08:51 +0200 mailte Stefan Schwarzer folgendes:
>> Now, I want to enable queries which display national as well as
>> regional values. I could probably work with independent queries, but
>> I think it would be "cleaner" and more efficient to get everything
>> into a single query.
>>
>> Can someone give me a hint how this would work?
>>
>> Thanks a lot!

> select ... UNION select ...

Apparently Stefan doesn't know about UNION, and thus he probably
doesn't know that UNION ALL is almost always preferrable.

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: subversion support?
Следующее
От: "Craig Hawkes"
Дата:
Сообщение: Re: Using Postgres as a "embedded" / SQL Lite database on Windows