Re: Query Planner Issue - View and regexp_replace?

Brandon Kane <brandonk98@yahoo.com> writes:
> -- Removing this condition from CASE statement in view corrects query planner problem.
>             WHEN NOT isnumeric(test_table.data::text) THEN
>                   regexp_replace(
>                         test_table.data::text,
>                         '[^0-9]'::text,
>                         ''::text,
>                         'g'::text)::bpchar::character varying
> --

What's isnumeric(), and is it by any chance marked volatile?
If so, that's your problem.

            regards, tom lane