Thread: Question about ordering views

Hi,

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.

regards,

depesz

--
hubert depesz lubaczewski
------------------------------------------------------------------------
     najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
      jest niesamowita wręcz łatwość unikania kontaktów z nim ...

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.