Re: [GENERAL] need trigger help

[Abdul-Wahid Paterson]

Excellent, I got it working...Thanks ;)

Abdul-Wahid

On 5/9/05, Mike Nolan <[EMAIL PROTECTED]> wrote:
> > So how can I create a trigger to automatically update the hash fields
> > on updates and inserts?
> 
> Something like the following works for me:
> 
> create or replace function public.my_trigger()
> returns trigger as '
> 
> NEW.hashfield = hashfunction(NEW.data1,NEW.data2);
> 
> RETURN NEW;
> END;
> ' language 'plpgsql';
> 
> 
> create trigger my_trig
> before insert or update on my_tablename
> for each row
> execute procedure public.my_trigger();
> 
> The 'RETURN NEW' part is very important, without it your hash field won't
> get updated at all.
> --
> Mike Nolan
> 
>

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] need trigger help

[Mike Nolan]

> So how can I create a trigger to automatically update the hash fields
> on updates and inserts?

Something like the following works for me:

create or replace function public.my_trigger()
returns trigger as '

NEW.hashfield = hashfunction(NEW.data1,NEW.data2);

RETURN NEW;
END;
' language 'plpgsql';


create trigger my_trig
before insert or update on my_tablename
for each row
execute procedure public.my_trigger();

The 'RETURN NEW' part is very important, without it your hash field won't
get updated at all.
--
Mike Nolan



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster