| From: | Harald Fuchs <hf0217x(at)protecting(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: "Concatenate" two queries - how? |
| Date: | 2007-10-24 19:51:13 |
| Message-ID: | pu7ilcz3ym.fsf@srv.protecting.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
In article <20071024132516(dot)GI19546(at)a-kretschmer(dot)de>,
"A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Hawkes | 2007-10-24 20:04:12 | Re: Using Postgres as a "embedded" / SQL Lite database on Windows |
| Previous Message | Joshua D. Drake | 2007-10-24 19:41:11 | Re: subversion support? |