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. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly