| From: | "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "PostgreSQL - General ML" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: IF ROW( NEW ) <> ROW( OLD ) |
| Date: | 2008-06-27 17:28:01 |
| Message-ID: | 396486430806271028q6dfc3614w9840452829ff123d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Jun 25, 2008 at 8:17 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I think IF ROW(NEW.*) <> ROW(OLD.*) will work in recent releases.
>
> Actually you'd better use IF ROW(NEW.*) IS DISTINCT FROM ROW(OLD.*) ...
> you really don't want to rely on <> as it will not give the behavior
> you want in the presence of null columns.
Thanks that worked!
--
Regards,
Richard Broersma Jr.
Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2008-06-27 17:57:00 | Re: Problem with FOUND |
| Previous Message | Scott Marlowe | 2008-06-27 17:15:35 | Re: compiling, performance of PostGreSQL 8.3 on 64-bit processors |