Re: a wierd query

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Yes you can. Try this:
(select string_A from main_table) union (select string_B from main_table)

Yasir

On Thu, 13 May 2004, ashok(at)kalculate(dot)com wrote:

> Date: Thu, 13 May 2004 04:07:08 -0400
> From: "ashok(at)kalculate(dot)com" <ashok(at)kalculate(dot)com>
> To: pgsql-sql(at)postgresql(dot)org
> Subject: [SQL] a wierd query
>
> hi
>
> i have a wierd problem and i require an equally weird query.
> 1) backgound
> Table test:
> CREATE TABLE main_table (
> string_A varchar( 20),
> string_B varchar( 20),
> );
> -- both columns are identical in nature and usage
> INSERT INTO main_table VALUES('abcd','qrst');
> INSERT INTO main_table VALUES('efgh','efgh');
> INSERT INTO main_table VALUES('ijkl','abcd');
> INSERT INTO main_table VALUES('abcd','ijkl');
> INSERT INTO main_table VALUES('qrst','uvwx');
>
> 2) problem:
>
> i require a query that gives me a result set of the form
>
> 'abcd'
> 'efgh'
> 'ijkl'
> 'qrst'
> 'uvwx'
>
> that is i require the dictinct values from (visualizing each column
> result as a set) the union of the two columns
>
> 3) questions
>
> a) is a query like this possible that can give me the desired result
> b) if so what would it be.
>
> 4) remarks
>
> i can get the solution using a temporary table and with repeated
> "insert into temporary select $column from main_table"
>
>
> thanks in advance
>
> ashok
>
> --------------------------------------------------------------------
> mail2web - Check your email from the web at
> http://mail2web.com/ .
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (NetBSD)

iQEVAwUBQKN2/+J7vYSSIbWdAQKklQf+JPhyMpbhEVX/4t70r1m6RFPXkm2VgbOz
Dyxkjhbko07c+YcnVbHmk/8D0d+1L0Qx23vytCfvqRS29O5tzwDFrSfHCZQ8WE4C
H7P0377jfa/LxgAeaUNnDfhhGj+qUI649i2QDSzdalVVwKtUl/aKdw0+evveuUXZ
QBYvVeoFU9KrnqBbQNW6AQOM8vfnYG3cxcb87krRy/b2EgZE462o2O3jGhqvlmrU
8eKJCrEnv4t53IOI3J2WECKbuSomTrUAqfUWbpL6g7zrOpkuCTqzTuOrx+7ISMTR
zyY36zUDeOB/A7u3PEh+wQz/Yqdq1Gu9GQ3kIsgao1WA+K3tj1ceKA==
=zMMM
-----END PGP SIGNATURE-----