Postgres Pro
Downloads
Home   >   mailing lists

Re: Hey! ORDER BY in VIEWS? - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Hey! ORDER BY in VIEWS?
Date
Msg-id Pine.LNX.4.30.0107152129390.677-100000@peter.localdomain
Whole thread Raw
In response to Hey! ORDER BY in VIEWS?  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: Hey! ORDER BY in VIEWS?
Re: Hey! ORDER BY in VIEWS?
List pgsql-sql
Tree view 
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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Hey! ORDER BY in VIEWS?
Next
From: "Josh Berkus"
Date:
Subject: Re: Hey! ORDER BY in VIEWS?