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@kalculate.com wrote:

> Date: Thu, 13 May 2004 04:07:08 -0400
> From: "ashok@kalculate.com" <ashok@kalculate.com>
> To: pgsql-sql@postgresql.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-----