Re: Adding order bys to the view definitions (7.4)

elein <elein@varlena.com> writes:
> Is there any case when PostgreSQL adds an order by
> to a view *definition* in 7.4?

I believe SELECT DISTINCT (or DISTINCT ON) will do that.
I have a vague recollection that GROUP BY might have done
so at one time as well, but it seems not to anymore.

            regards, tom lane