Intersect and order by

Поиск
Список
Период
Сортировка
От Michaël Fiey
Тема Intersect and order by
Дата
Msg-id 006b01c0a1b0$8c3b81c0$6400a8c0@pc03
обсуждение исходный текст
Ответы Re: Intersect and order by  (Michael Fork <mfork@toledolink.com>)
Re: Intersect and order by  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

I don't understand what's happening with my command
I read postgresql docs, it should work...What's the problem ?
The command is :

select col1
from table
where <conditions 1>
intersect
select col1
from table
where <conditions 2>
order by col1

It does not work and return "get_sortgroupclause_expr: ORDER/GROUP BY
expression not found in targetlist"

I use pgsql 7.03 ont redhat 7.0.

Any help would be appreciated

michael




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slowdown problem when writing 1.7million records
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Slowdown problem when writing 1.7million records