From: ashok@kalculate.com <ashok@kalculate.com>
To: pgsql-sql@postgresql.org
Subject: a wierd query
Date: Thu, 13 May 2004 04:07:08 -0400
Message-ID: <323910-220045413878445@M2W099.mail2web.com> (raw)
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/ .
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ashok@kalculate.com
Subject: Re: a wierd query
In-Reply-To: <323910-220045413878445@M2W099.mail2web.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox