Postgres Pro
Downloads
Home   >   mailing lists

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

Adding order bys to the view definitions (7.4)

From
elein
Date:
Is there any case when PostgreSQL adds an order by
to a view *definition* in 7.4?  I have evidence
that
   create view ....
results in
    create view .... ORDER BY ...
as shown by \d viewname.
The view does a five way ordinary join.

Any definitive answer would be very helpful.

Thanks,

Elein
elein@varlena.com
--------------------------------------------------------------
elein@varlena.com        Varlena, LLC        www.varlena.com
(510)655-2584(o)                             (510)543-6079(c)

          PostgreSQL Consulting, Support & Training

PostgreSQL General Bits   http://www.varlena.com/GeneralBits/
--------------------------------------------------------------
I have always depended on the [QA] of strangers.

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

From
Tom Lane
Date:
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