Re: Query Planner Issue - View and regexp_replace?

Поиск
Список
Период
Сортировка
От Brandon Kane
Тема Re: Query Planner Issue - View and regexp_replace?
Дата
Msg-id 981019.27216.qm@web51707.mail.re2.yahoo.com
обсуждение исходный текст
Ответ на Re: Query Planner Issue - View and regexp_replace?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Query Planner Issue - View and regexp_replace?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Yes, this turns out to be a volatile user-defined function.  Is there some specific part of the
documentation you can point me to that helps explain why a volatile function might affect the plan
for a column not involved in select or join operations?  I happened to pull this function off a
posting somewhere, so after reviewing the volatility keywords, volatile is clearly not required,
so that will be an easy fix.  I'm still interested in knowing more about how volatility fits into
the query planner.

Thanks for your help.
-Brandon

--- Tom Lane wrote:

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



      ____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page.
http://www.yahoo.com/r/hs

В списке pgsql-novice по дате отправления:

Предыдущее
От: Mark S
Дата:
Сообщение: pg_dump, pg_restore and template relationships
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump, pg_restore and template relationships