Re: Could regexp_matches be immutable?

On Wed, Oct 14, 2009 at 05:14:31PM -0400, Andrew Dunstan wrote:
> David Fetter wrote:
>> On Wed, Oct 14, 2009 at 04:51:03PM -0400, Tom Lane wrote:
>>
>>> Rod Taylor <rod(dot)taylor(at)gmail(dot)com> writes:
>>>
>>>> I tried making a functional index based on an expression
>>>> containing the 2 argument regexp_matches() function. Is there a
>>>> reason why this function is not marked immutable instead of
>>>> normal?
>>>>
>>> regex_flavor affects its result.
>>>
>>
>> Speaking of which, can we see about deprecating and removing this GUC?
>> I've yet to hear of anyone using a flavor other than the default.
>
> You have now. I have a client who sadly uses a non-default setting. And
> on 8.4, what is more.

OK, now I've heard of one. I still think we should deprecate and
remove. Say, deprecate this next release and remove for the following
one?

> There are more things under heaven and earth ....

My philosophy doesn't include infinite backward compatibility.
Neither do heaven and earth, come to think of it. :)

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate