Re: Could regexp_matches be immutable?

On Oct 21, 2009, at 9:40 AM, David E. Wheeler wrote:

> On Oct 21, 2009, at 9:37 AM, Tom Lane wrote:
>
>>> Ooh, yeah, dunno how I missed that.
>>
>> I think we're probably stuck in 8.4, but we should fix it going
>> forward.  Would you make a quick check if any of the other citext
>> functions have the same bug?
>
> I've fixed it in my [version for 8.3](https://svn.kineticode.com/citext/trunk 
> ). Is there a straight-foward way to check such a thing  
> programmatically, with a query perhaps? Or should I just put aside  
> an hour to do an audit?

FWIW, I think that this is a bug, and that the variation from the text  
version will be unexpected. I recommend fixing it for 8.4.2.

Best,

David