"Regina Obe" <lr(at)pcorp(dot)us> writes:
> I figured out the culprit was the change in CASE WHEN behavior with set
> returning functions
> Had a criteria something of the form:
> CASE WHEN some_condition_dependent_on_sometable_that_resolves_to_false THEN
> (regexp_matches(...))[1] ELSE ... END
> FROM sometable;
You might want to consider changing such usages to use regexp_match()
instead of regexp_matches().
regards, tom lane