Postgres Pro
Downloads
Home   >   mailing lists

Re: order by and view def. - Mailing list pgsql-general

From Tom Lane
Subject Re: order by and view def.
Date
Msg-id 29320.1308232688@sss.pgh.pa.us
Whole thread Raw
In response to order by and view def.  (salah jubeh <s_jubeh@yahoo.com>)
List pgsql-general
Tree view 
salah jubeh <s_jubeh@yahoo.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

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Constraint to ensure value does NOT exist in another table?
Next
From: "Gauthier, Dave"
Date:
Subject: Re: Constraint to ensure value does NOT exist in another table?