From: | Emile D Snyder <emile(at)cosource(dot)com> |
---|---|
To: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
Cc: | PGSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: foreign keys - script |
Date: | 2000-08-29 18:39:21 |
Message-ID: | Pine.LNX.4.10.10008291330500.19383-100000@everclear.cosource.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= | 2000-08-29 18:48:22 | Re: PG 7.0.2 Install |
Previous Message | Lamar Owen | 2000-08-29 18:25:34 | Re: PG 7.0.2 Install |