INTERSECT AND ORDER BY

Поиск
Список
Период
Сортировка
Искать
От
Gary DeSorbo
Тема
INTERSECT AND ORDER BY
Дата
Msg-id
v04210106b74d66d613fe@[172.16.0.83]
Список
Дерево обсуждения
INTERSECT AND ORDER BY Gary DeSorbo <isasitis@uchicago.edu>
Re: INTERSECT AND ORDER BY Bruno Wolff III <bruno@wolff.to>
Re: INTERSECT AND ORDER BY Tom Lane <tgl@sss.pgh.pa.us>
I am trying to use the query below:

SELECT date_worked, hours_worked
FROM hours
WHERE date_worked < '8/15/2001'
INTERSECT
SELECT date_worked, hours_worked
FROM hours
WHERE date_worked > '8/8/2001'
ORDER BY date_worked

but Postgres does not seem to like the ORDER BY 	clause. Does 
anyone know if it is possible to use ORDER BY in conjunction with an 
INTERSECT statement? Does anyone have any alternative suggestions? I 
cannot use a temporary table because this is a Web-based application. 
Thanks in advance for your help.

Gary
В списке pgsql-general по дате отправления
От: Peter Eisentraut
Дата:
От: Tom Lane
Дата:
FAQ