Re: ORDER BY in definition of views

From: Niall Smart <niall(dot)smart(at)ebeon(dot)com>
To: Michael Ansley <Michael(dot)Ansley(at)intecsystems(dot)co(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: ORDER BY in definition of views
Date: 2000-06-08 15:41:48
Message-ID: 393FBEBC.B2F8A691@ebeon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bernie Huang 2000-06-08 17:01:04 SQL 'Case When...'
Previous Message Tom Lane 2000-06-08 14:39:26 Re: ORDER BY in definition of views