VIEW / ORDER BY + UNION

Поиск
Список
Период
Сортировка
От WeiShang
Тема VIEW / ORDER BY + UNION
Дата
Msg-id cv2ea4$1cfv$2@news.hub.org
обсуждение исходный текст
Ответы Re: VIEW / ORDER BY + UNION  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-sql
Hi, I have created a view like this :

CREATE VIEW v1 AS (SELECT orderno,weekday,time FROM t1,t2 where
t1.orderno=t2.orderno);

if I create a SQL statment:

(SELECT orderno FROM v1 WHERE weekday='MON' ORDER BY orderno)
UNION
(SELECT orderno FROM v1 WHERE weekday='WED' ORDER BY orderno)
UNION
(SELECT orderno FROM v1 WHERE weekday='FRI' ORDER BY orderno);

Will the whole result will be sorted by the field orderno?

Thanks,
WeiShang













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

Предыдущее
От: CoL
Дата:
Сообщение: Re: VIEW / ORDER BY + UNION
Следующее
От: "T- Bone"
Дата:
Сообщение: Comments on subquery performance