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 по дате отправления