Re: [BUGS] Selecting from a VIEW is NOT optimized like a similar SELECT statement

2003-11-11 Thread Tom Lane
SHADOWPLAY - Dave Adams <[EMAIL PROTECTED]> writes: > When using a view on a table, a select on the view is not as optimized as > a select directly from the table. PG 7.3 is not very bright about pushing WHERE quals down into a sub-select that involves DISTINCT ON. 7.4 is a tad smarter, and I th

[BUGS] Selecting from a VIEW is NOT optimized like a similar SELECT statement

2003-11-11 Thread SHADOWPLAY - Dave Adams
POSTGRESQL BUG REPORT TEMPLATE Your name : David B. Adams Your email address : jugular (