Re: full join question...

Поиск
Список
Период
Сортировка
От Niklas Johansson
Тема Re: full join question...
Дата
Msg-id DF77522E-8DE8-4E3F-9D3D-FEA48B50A3D4@tele2.se
обсуждение исходный текст
Ответ на Re: full join question...  ("Jonas F. Henriksen" <jonas.f.henriksen@imr.no>)
Список pgsql-general
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);



Sincerely,

Niklas Johansson





В списке pgsql-general по дате отправления:

Предыдущее
От: "Dawid Kuroczko"
Дата:
Сообщение: DELETE FROM pg_class
Следующее
От: "Rodrigo De Le�"
Дата:
Сообщение: Re: Best practice for specifying an interval