Skip site navigation (1) Skip section navigation (2)

Re: foreign keys - script

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 (view raw or flat)
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
> 


In response to

pgsql-general by date

Next:From: Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=Date: 2000-08-29 18:48:22
Subject: Re: PG 7.0.2 Install
Previous:From: Lamar OwenDate: 2000-08-29 18:25:34
Subject: Re: PG 7.0.2 Install

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group