Have you considered one large table with all of the columns from the various
spreadsheets, then a separate view for each customer?
- Original Message
From: Mike Diehl <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org
Sent: Wednesday, September 17, 2008 12:29:15 PM
Subject: [GENERAL
This works in oracle:
SELECT aid, bid
FROM aidbid
WHERE aid < bid
UNION
SELECT bid, aid
FROM aidbid
WHERE bid < aid
Rhys Stewart <[EMAIL PROTECTED]> wrote:
Hi all,
have the following table
aid| bid
--
1|5
2|6
3|7
4|9
5|1
6|2
7|3
