Re: "Concatenate" two queries - how? - Mailing list pgsql-general

From Harald Fuchs
Subject Re: "Concatenate" two queries - how?
Date
Msg-id pu7ilcz3ym.fsf@srv.protecting.net
Whole thread Raw
In response to "Concatenate" two queries - how?  (Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>)
List 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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: subversion support?
Next
From: "Craig Hawkes"
Date:
Subject: Re: Using Postgres as a "embedded" / SQL Lite database on Windows