Re: Hey! ORDER BY in VIEWS?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Hey! ORDER BY in VIEWS?
Дата
Msg-id Pine.LNX.4.30.0107152129390.677-100000@peter.localdomain
обсуждение исходный текст
Ответ на Hey! ORDER BY in VIEWS?  ("Josh Berkus" <josh@agliodbs.com>)
Ответы Re: Hey! ORDER BY in VIEWS?  ("Josh Berkus" <josh@agliodbs.com>)
Re: Hey! ORDER BY in VIEWS?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Josh Berkus writes:

> Hey!  I thought you couldn't do ORDER BY in views ... yet I just did.
> Is this a new thing, or am I just getting my Trasact-SQL and my
> PostgreSQL mixed up again?

I think it was allowed from 7.1 on to enable LIMIT in views to work
sensibly.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Hey! ORDER BY in VIEWS?
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: Hey! ORDER BY in VIEWS?