Re: Question about ordering views - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Question about ordering views
Date
Msg-id Pine.BSF.4.10.10011051100230.6169-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Question about ordering views  (hubert depesz lubaczewski <depesz@depesz.pl>)
List pgsql-general
I don't think you can do it with views/rules on 7.0, but order by on views
seems to work on current sources so should be in the 7.1 beta.

Stephan Szabo
sszabo@bigpanda.com

On Sun, 5 Nov 2000, hubert depesz lubaczewski wrote:

> I'm wondering if it is possible to make view (or procedure or triger or rule or
> something) to force SELECTs to this view (rule, procedure or something) to
> force always using predefined ORDER BY statement without removing possibility
> to use WHERE statement to this SELECT.


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Referential integrity question
Next
From: "William H. Geiger III"
Date:
Subject: Re: Referential integrity question