Hosting Provided By

Re: [GENERAL] "Concatenate" two queries - how?

From: Harald Fuchs <hf0217x(at)protecting.net>
Date: Wed Oct 24 2007 - 15:51:13 EDT

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.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly

Received on Wed Oct 24 15:55:05 2007

This message: [ Message body ]
Next message: Craig Hawkes: "Re: [GENERAL] Using Postgres as a "embedded" / SQL Lite database on Windows"
Previous message: Joshua D. Drake: "Re: [GENERAL] subversion support?"
In reply to: A. Kretschmer: "Re: [GENERAL] "Concatenate" two queries - how?"
Next in thread: Gauthier, Dave: "Re: [GENERAL] "Concatenate" two queries - how?"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 18:48:48 EDT