Postgres Pro
Downloads
Home   >   mailing lists

Re: query_is_distinct_for does not take into account set returning functions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: query_is_distinct_for does not take into account set returning functions
Date
Msg-id 7496.1404830713@sss.pgh.pa.us
Whole thread Raw
In response to query_is_distinct_for does not take into account set returning functions  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
Tree view 
David Rowley <dgrowleyml@gmail.com> writes:
> I think we should probably include the logic to test for set returning
> functions into query_is_distinct_for.

It strikes me that there's only a problem if the SRF is in a tlist entry
that is not one of the DISTINCT or GROUP BY columns, respectively.  It
may not be worth the extra complexity to figure that out, though.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Extending constraint exclusion for implied constraints/conditions
Next
From: geohas
Date:
Subject: How to use Makefile - pgxs without gcc -O2 ?