Re: Update on tables when the row doesn't change - Mailing list pgsql-general

Ragnar Hafstað wrote:
> On Wed, 2005-05-25 at 13:09 +0200, Sebastian Böck wrote:
>
>>Dawid Kuroczko wrote:
>>
>>
>>>Be wary of the NULL values though. :)  Either don't use them, add
>>>something like 'AND (text1 <> NEW.text1 OR text1 IS NULL OR NEW.text1
>>>IS NULL)' or something more complicated. :)
>>
>>Thanks for the notice, but I have a special operator for this:
>>
>>CREATE OR REPLACE FUNCTION different (ANYELEMENT, ANYELEMENT) RETURNS
>
>
> and then there is the 'IS DISTINCT FROM' construct
> http://www.postgresql.org/docs/8.0/static/functions-comparison.html#AEN6094
>

Much easier :)

Thanks

Sebastian