Skip site navigation (1) Skip section navigation (2)

RE: [HACKERS] JOIN syntax. Examples?

From: Dan Gowin <DGowin(at)avantec(dot)net>
To: "'Thomas G(dot) Lockhart'" <lockhart(at)alumni(dot)caltech(dot)edu>, "PGSQL HACKERS (E-mail)" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: RE: [HACKERS] JOIN syntax. Examples?
Date: 1998-12-11 15:25:40
Message-ID: 43A3A1806104D211988500A0C9B576EE7CE039@avantec_exc.avantec.net (view raw or flat)
Thread:
Lists: pgsql-hackers
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(at)alumni(dot)caltech(dot)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

pgsql-hackers by date

Next:From: Terry MackintoshDate: 1998-12-11 15:36:30
Subject: follow up to: alter table bug???
Previous:From: Dan GowinDate: 1998-12-11 15:21:57
Subject: PostgreODBC error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group