From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
---|---|
To: | Mike Mascari <mascarm(at)mascari(dot)com>, Timothy Dyck <Timothy_Dyck(at)zd(dot)com> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] PC Week Labs benchmark results |
Date: | 2000-02-04 16:26:29 |
Message-ID: | 3.0.1.32.20000204082629.00fd8860@mail.pacifier.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
At 04:38 AM 2/4/00 -0500, Mike Mascari wrote:
>That's always been annoying, although it can be simulated
>easily with:
>
>SELECT t1.x, t2.y
>FROM t1, t2
>WHERE t1.x = t2.x
>UNION
>SELECT t1.x, NULL
>FROM t1 WHERE NOT EXISTS ( SELECT t2.x FROM t2 WHERE t1.x =
>t2.x );
SOME - but not all - outer joins can be simulated with this
trick. Others require subselects in the target list, etc.
And the union form gets really messy when a query includes more
than one outer join.
- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
From | Date | Subject | |
---|---|---|---|
Next Message | Ed Loehr | 2000-02-04 16:39:05 | Re: [HACKERS] PC Week Labs benchmark results |
Previous Message | Tom Lane | 2000-02-04 15:35:31 | Re: [HACKERS] PC Week Labs benchmark results |