Postgres Pro
Downloads
Home   >   mailing lists

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

From A. Kretschmer
Subject Re: "Concatenate" two queries - how?
Date
Msg-id 20071024132516.GI19546@a-kretschmer.de
Whole thread Raw
In response to "Concatenate" two queries - how?  (Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>)
List pgsql-general
Tree view 
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 ...


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Re: "Concatenate" two queries - how?
Next
From: "Stanislav Raskin"
Date:
Subject: Re: "Concatenate" two queries - how?