| From: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
|---|---|
| To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
| Cc: | pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | AW: AW: A fine point about OUTER JOIN semantics |
| Date: | 2000-09-06 15:02:01 |
| Message-ID: | 11C1E6749A55D411A9670001FA687963368068@sdexcsrv1.f000.d0188.sd.spardat.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Oh, my mistake, I forgot that the WHERE clause would filter out NULLs.
> Try
> SELECT * FROM t1 LEFT JOIN t2 ON (x = y) WHERE y <> 2 OR y IS NULL;
x y
1 1
3 NULL
4 4
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Perdue | 2000-09-06 15:14:42 | Re: Fragged State in 7.0.2 |
| Previous Message | Tom Lane | 2000-09-06 14:52:28 | Re: Fragged State in 7.0.2 |