| From: | Sebastian Böck <sebastianboeck(at)freenet(dot)de> |
|---|---|
| To: | Ragnar Hafstað <gnari(at)simnet(dot)is> |
| Cc: | Dawid Kuroczko <qnex42(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Update on tables when the row doesn't change |
| Date: | 2005-05-25 13:48:49 |
| Message-ID: | 42948241.9090302@freenet.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-05-25 14:06:40 | Re: postmaster fails to start |
| Previous Message | Ragnar Hafstað | 2005-05-25 13:34:25 | Re: Update on tables when the row doesn't change |