Postgres Pro
Downloads
Home   >   mailing lists

Re: query question really cant give a summary here so read the body ;-) - Mailing list pgsql-general

From James Strater
Subject Re: query question really cant give a summary here so read the body ;-)
Date
Msg-id 957947.86428.qm@web33803.mail.mud.yahoo.com
Whole thread Raw
In response to query question really cant give a summary here so read the body ;-)  ("Rhys Stewart" <rhys.stewart@gmail.com>)
List pgsql-general
Tree view
This works in oracle:
 
SELECT
 aid, bid
FROM
 aidbid
WHERE
 aid < bid
UNION
SELECT
 bid, aid
FROM
 aidbid
WHERE
 bid < aid


Rhys Stewart <rhys.stewart@gmail.com> wrote:
Hi all,

have the following table

aid    | bid
--------------
1    |5
2    |6
3    |7
4    |9
5    |1
6    |2
7    |3
8    |10
9    |4
10  |8
both aid & bid represent the same data in another table, but the table has duplicate data and i did a self-join to get the id's out. The question is how do i get a distinct listing between both columns

like
aid | bid
-----------
1|5
2|6
3|7
4|9
10|8

Have been racking my brain for the past hour....any suggestions?

Thanks
Rhys

Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: query question really cant give a summary here so read the body ;-)
Next
From: "Emiliano Moscato"
Date:
Subject: Stored procedures in C