On Tue, Dec 15, 2009 at 1:23 AM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > Hello > > NEW and OLD is comparable in 8.4. In 8.3 and older you have to use > little bit different syntax > > http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Fast_compare_variables_NEW_and_OLD_in_trigger.27s_body >
Thanks, Pavel! This is exactly what I was looking for. I am able to use IF ROW(NEW.*) IS NOT DISTINCT FROM ROW(OLD.*) THEN ... on 8.3. Josh -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general