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.