elein <[EMAIL PROTECTED]> 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.
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,
El
