CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED] 04/03/29 15:58:04
Modified files:
src/backend/optimizer/util: pathnode.c
Log message:
Use fuzzy comparison of path costs in add_path(), so that paths with the
same path keys and
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>> Teach is_distinct_query to recognize that GROUP BY forces a subquery's
>> output to be distinct, if all the GROUP BY columns appear in the output.
>> Per suggestion from Dennis Haney.
> Will this have should-be-in-release-notes side effects ju
Teach is_distinct_query to recognize that GROUP BY forces a subquery's
output to be distinct, if all the GROUP BY columns appear in the output.
Per suggestion from Dennis Haney.
Will this have should-be-in-release-notes side effects just as the
results of a DISTINCT over a
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED] 04/03/02 12:42:20
Modified files:
src/backend/optimizer/util: pathnode.c
Log message:
Teach is_distinct_query to recognize that GROUP BY forces a subquery's
output to be distinct
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED] 04/01/18 23:49:41
Modified files:
src/backend/optimizer/util: pathnode.c
Log message:
Recognize that IN subqueries return already-unique results if they use
UNION/INTERSECT/EXCEP
