Hi, On 2017-05-28 14:03:26 -0400, Tom Lane wrote: > I think it would be possible to teach eval_const_expressions that > it must not discard CASE/COALESCE subexpressions that contain SRFs, > which would preserve the rule that expression simplification doesn't > change the query semantics.
That sounds like a good idea. Do you want to write up a patch, or should I? I can, but I'd want to finish the walsender panic and other signal handling stuff first (mostly waiting for review for now). > Another possibility is to say that we've broken this situation > irretrievably and we should start throwing errors for SRFs in > places where they'd be conditionally evaluated. That's not real > nice perhaps, but it's better than the way things are right now. I'd be ok with that too, but I don't really see a strong need so far. Greetings, Andres Freund -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers