I run three HP minicomputers and two Sun Ultra 3000 all with
Oracle 7.3 and one with Oracle 8.0 .
Send it to me.
D.
-----Original Message-----
From: Thomas G. Lockhart [mailto:lockhart@alumni.caltech.edu]
Sent: Friday, December 11, 1998 1:36 AM
To: Postgres Hackers List
Subject: [HACKERS] JOIN syntax. Examples?
Well, I've started looking through my books for info on joins. The cross
join was pretty easy:
postgres=> select * from (a cross join b);
i| j|i| k
-+----+-+--
1|10.1|1|-1
2|20.2|1|-1
4| |1|-1
<snip>
which I've put into my copy of the parser.
Does anyone have a commercial installation which has good support for
SQL92 joins? I'd like to send some small test cases to verify that I
understand what the behavior should be.
Also, if anyone has worked with join syntax, outer joins especially, it
would be great to get some test case contributions...
- Tom