Re: non-deterministic error related to MIN/MAX optimization - Mailing list pgsql-bugs

From Tom Lane
Subject Re: non-deterministic error related to MIN/MAX optimization
Date
Msg-id 17092.1219717611@sss.pgh.pa.us
Whole thread Raw
In response to non-deterministic error related to MIN/MAX optimization  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: non-deterministic error related to MIN/MAX optimization
List pgsql-bugs
Jeff Davis <pgsql@j-davis.com> writes:
> => select max(a), generate_series(1,2) as g from foo order by g desc;
> ERROR:  set-valued function called in context that cannot accept a set

This strikes me as a pretty useless query, so the fact that it doesn't
work doesn't bother me.  It's mostly accidental that there are any
variants that do work, I think.  Why would you want a SRF in a sort key?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Jeff Davis
Date:
Subject: non-deterministic error related to MIN/MAX optimization
Next
From: Craig Ringer
Date:
Subject: Re: BUG #4374: pg_restore does not restore public schema comment