> Conversion of the pattern to an index qualification requires that the
> pattern be a plan-time constant.  STABLE functions, by definition,
> are not that.

Thank you very much


I guess it is correct to assume that the same applies to regular expressions stored in pl/pgsql variables/arguments then, as they're inspected after the plan is cached?


Is dynamic SQL the recommended/only way around this?


Regards

Fabio Ugo Venchiarutti


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to