Postgres Pro
Downloads
Home   >   mailing lists

Re: subquery results bypassed - Mailing list pgsql-bugs

From Tom Lane
Subject Re: subquery results bypassed
Date
Msg-id 4426.996551447@sss.pgh.pa.us
Whole thread Raw
In response to subquery results bypassed  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> [ SELECT DISTINCT ON in a subquery-in-FROM misbehaves ]

Oooh, good catch!  I had thought about pushing down quals into a SELECT
DISTINCT, and concluded it was OK because the qual would eliminate all
or none of a set of not-DISTINCT rows.  But I forgot about DISTINCT ON
:-(.

Will have a source patch for this tomorrow, if that helps.

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: subquery results bypassed
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: 'order by' and 'desc' not working in subquery using 'not in'