Re: [HACKERS] JOIN syntax. Examples?

On Fri, 11 Dec 1998, Thomas G. Lockhart wrote:

> 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...

I have access to several different versions of Oracle at work...if you
want to send me your test cases, go for it...work email is
'marc.fournier@acadiau.ca'...

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org