Re: foreign keys - script

This question was me actually, and thanks for the info! Is the
development list archived somewhere publicly accessible?

thanks,
-emile

On Tue, 29 Aug 2000, Ross J. Reedstrom wrote:

> As to your other question, regarding LEFT JOIN: that's 'not yet
> implemented'. IF you don't have too many of them, or their not too
> complicated, you can work around it with a UNION, such as:
>
> SELECT a,b from foo,bar where foo.b = bar.b
> UNION
> SELECT a,NULL from foo where foo.b is null;
>
> That gives you a LEFT JOIN on foo and bar on field 'b'.
>
> There's currently some discussion going on on HACKERS concerning what
> will be needed to make OUTER JOINs happen for 7.1 (current talk is
> release sometime in November)
>
> Ross
> --
> Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
> NSBRI Research Scientist/Programmer
> Computer and Information Technology Institute
> Rice University, 6100 S. Main St., Houston, TX 77005
>