Re: order by and view def.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: salah jubeh <s_jubeh(at)yahoo(dot)com>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: order by and view def.
Date: 2011-06-16 13:58:08
Message-ID: 29320.1308232688@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

salah jubeh <s_jubeh(at)yahoo(dot)com> writes:
> There is something strange with the views definitions, I have "order by"
> statement amended to the views where the view is ordered by all the columns in
> the view. Is this a common behavior?

> Ps: I am using postgresql 8.3

If the views use SELECT DISTINCT, PG versions before 8.4 will force all
the DISTINCT columns to appear in the sort list. That's an
implementation detail we got rid of in 8.4 ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2011-06-16 14:06:31 PostgreSQL 9.0 or 9.1 ?
Previous Message Peter Geoghegan 2011-06-16 13:56:13 Re: Constraint to ensure value does NOT exist in another table?