Bypassing useless ORDER BY in a VIEW - Mailing list pgsql-performance

From Robins Tharakan
Subject Bypassing useless ORDER BY in a VIEW
Date
Msg-id 36af4bed0802280631ja29c636w2256fb329e14b95e@mail.gmail.com
Whole thread Raw
Responses Re: Bypassing useless ORDER BY in a VIEW
List pgsql-performance
Hi,

While designing a complex database structure I wanted to ask a basic question about views.

If I give an ORDER BY clause in a VIEW and then use it in another query where the VIEW's ORDER BY is immaterial, would the planner be able to discard this ORDER BY clause ?

Any pointers / feedbacks would be really helpful.

Regards,
Robins Tharakan

pgsql-performance by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: t1.col like '%t2.col%'
Next
From: Tom Lane
Date:
Subject: Re: Bypassing useless ORDER BY in a VIEW