Re: [GENERAL] order by and view def.

2011-06-16 Thread Tom Lane
salah jubeh 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 version

[GENERAL] order by and view def.

2011-06-16 Thread salah jubeh
Hello, 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 Regards