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(dot)fournier(at)acadiau(dot)ca'...

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