Re: Question about ordering views

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: hubert depesz lubaczewski <depesz(at)depesz(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about ordering views
Date: 2000-11-05 19:05:17
Message-ID: Pine.BSF.4.10.10011051100230.6169-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)bigpanda(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John McKown 2000-11-05 19:42:27 Re: where to find postgresql jobs in the Washington, DC area??
Previous Message Stephan Szabo 2000-11-05 18:59:21 Re: Referential integrity question