Re: Empty Updates, ON UPDATE triggers and Rules

On Thu, 6 Aug 2009 13:15:57 -0400
Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:

> CREATE OR REPLACE FUNCTION set_last_modified ()
> RETURNS TRIGGER
> AS $$
> BEGIN
> IF NEW != OLD THEN -- 8.4 syntax
> NEW.last_modified = NOW();
> END IF;
>
> RETURN NEW;
> END;
> $$ LANGUAGE PLPGSQL;

Thanks - I'll try this. Since using 8.3 sounds like I need to
replace above with:

IF old::text != new::text

?

I'll give it a go anyway....

Josh