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@rice.edu> 
> NSBRI Research Scientist/Programmer
> Computer and Information Technology Institute
> Rice University, 6100 S. Main St.,  Houston, TX 77005
>