Brandon Kane <brandonk98(at)yahoo(dot)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