Re: full join question...
От | Jonas F. Henriksen |
---|---|
Тема | Re: full join question... |
Дата | |
Msg-id | 1144262489.4813.59.camel@nmd8441-2 обсуждение исходный текст |
Ответ на | full join question... ("Jonas F. Henriksen" <jonas.f.henriksen@imr.no>) |
Ответы |
Re: full join question...
|
Список | pgsql-general |
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 ...with missing rows for a depth appearing as missing values... Jonas:)) On Wed, 2006-04-05 at 20:06 +0200, Niklas Johansson wrote: > On 5 apr 2006, at 18.37, Jonas F. Henriksen wrote: > > ehh, sorry, yes, I also want to retrieve other values from the table, > > but I left them out for clarity (which made it maby less clear...). > > Maybe it makes more sense if you define the table as > > CREATE TABLE testtable ( > > depth integer, > > measuretype integer, > > operation integer, > > value float > > ); > > ...where I'm actually interested in the value... > > > Well, is there something else I don't get or couldn't you just select > that as well (perhaps without the DISTINCT then)? > > SELECT depth, value FROM testtable WHERE measuretype IN (1040, 4001); > > > > Mvh, > > Niklas Johansson > Tel: 0322-108 18 > Mobil: 0708-55 86 90 > > >
В списке pgsql-general по дате отправления: