Re: Query Planner Issue - View and regexp_replace?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brandon Kane <brandonk98(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Query Planner Issue - View and regexp_replace?
Date: 2008-02-17 23:50:04
Message-ID: 2526.1203292204@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mark S 2008-02-18 01:11:39 pg_dump, pg_restore and template relationships
Previous Message Brandon Kane 2008-02-17 23:05:13 Query Planner Issue - View and regexp_replace?