From: | "Lee Harr" <missive(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Apparently I don't understand full outer joins.... |
Date: | 2005-01-26 21:35:46 |
Message-ID: | BAY2-F25DDDFB85CE0390ABA3FE1B1870@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>select
> coalesce(a.n,0) as a,
> coalesce(b.n,0) as b,
> coalesce(c.n,0) as c,
> coalesce(a.s,b.s,c.s) as s
>from
> ( select 1 as n, 0 as s) a full outer join
> ( select 1 as n, 1 as s) b full outer join
> ( select 2 as n, 2 as s) c
>on
> a.s = b.s and
> b.s = c.s
>
>
>.... and get a syntax error at the end of my query. Apparently what I'm
>trying to do doesn't make sense?
>
Maybe this is what you want...
select
coalesce(a.n,0) as a,
coalesce(b.n,0) as b,
coalesce(c.n,0) as c,
coalesce(a.s,b.s,c.s) as s
from
( select 1 as n, 0 as s) a full outer join
( select 1 as n, 1 as s) b
on a.s = b.s
full outer join
( select 2 as n, 2 as s) c
on
b.s = c.s
a | b | c | s
---+---+---+---
1 | 0 | 0 | 0
0 | 1 | 0 | 1
0 | 0 | 2 | 2
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2005-01-26 21:42:07 | more information for SRF function |
Previous Message | Tom Lane | 2005-01-26 20:01:28 | Re: Lower case |