Re: full join question...
От | Jonas F. Henriksen |
---|---|
Тема | Re: full join question... |
Дата | |
Msg-id | 1144308678.4052.2.camel@nmd8441-2 обсуждение исходный текст |
Ответ на | Re: full join question... (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
Thanks Tom, that worked great!! Regards Jonas:)) On Wed, 2006-04-05 at 15:09 -0400, Tom Lane wrote: > "Jonas F. Henriksen" <jonas.f.henriksen@imr.no> writes: > > Well, the problem is I want the result on one row for each depth, so it > > will fit nicely into a table, like this: > > > depth measuretype1_value measuretype2_value > > 10 1.78 2.55 > > 20 2.12 > > 30 3.12 > > 40 1.3 1.4 > > I think what you have to do is filter the rows according to measuretype > *before* you join them. Something like > > select * from > (select depth, value as measuretype1_value from testtable > where measuretype = 1040) ss1 > full join > (select depth, value as measuretype2_value from testtable > where measuretype = 4001) ss2 > using (depth); > > regards, tom lane
В списке pgsql-general по дате отправления: