Postgres Pro
Downloads
Home   >   mailing lists

Re: Operators based on non-IMMUTABLE functions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Operators based on non-IMMUTABLE functions
Date
Msg-id 8960.1236280236@sss.pgh.pa.us
Whole thread Raw
In response to Operators based on non-IMMUTABLE functions  (Joshua Tolley <eggyknap@gmail.com>)
List pgsql-hackers
Tree view 
Joshua Tolley <eggyknap@gmail.com> writes:
> I've recently run into a problem with a datatype whose operators are
> based on functions not marked IMMUTABLE. Although there might be good
> reasons to have such a thing, it seems like it might be a valuable
> warning message if you create an operator based on an non-IMMUTABLE
> function. Comments?

No, it wouldn't be a good idea.  There are plenty of such operators.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Operators based on non-IMMUTABLE functions
Next
From: "Kevin Grittner"
Date:
Subject: Re: Expanding the length of a VARCHAR column should not induce a table rewrite