Re: Query Planner Issue - View and regexp_replace? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Query Planner Issue - View and regexp_replace?
Date
Msg-id 2526.1203292204@sss.pgh.pa.us
Whole thread Raw
In response to Query Planner Issue - View and regexp_replace?  (Brandon Kane <brandonk98@yahoo.com>)
Responses Re: Query Planner Issue - View and regexp_replace?  (Brandon Kane <brandonk98@yahoo.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Brandon Kane
Date:
Subject: Query Planner Issue - View and regexp_replace?
Next
From: Mark S
Date:
Subject: pg_dump, pg_restore and template relationships