Re: ORDER BY in definition of views

Поиск
Список
Период
Сортировка
От Niall Smart
Тема Re: ORDER BY in definition of views
Дата
Msg-id 393FBEBC.B2F8A691@ebeon.com
обсуждение исходный текст
Ответ на RE: ORDER BY in definition of views  (Michael Ansley <Michael.Ansley@intecsystems.co.uk>)
Список pgsql-sql
Michael Ansley wrote:
> 
> Would there be a particular reason to do this?
> 

I like to define views for lookups  (i.e. job titles,
departments, accounts, whatever).  It would be nice
if I could just do a select * from whatever_vw instead
of having to remember to put the order by whatever_name
clause.  Admittedly its no biggie, but it is nice-to-have.


Niall


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

Предыдущее
От: Michael Ansley
Дата:
Сообщение: RE: ORDER BY in definition of views
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ORDER BY in definition of views