Re: [HACKERS] plpgsql lacks generic identifier for record in triggers...

2004-11-25 Thread Weiping
db=# CREATE FUNCTION schma.tbl_ins_upd() RETURNS TRIGGER AS 'BEGIN EXECUTE public.mc_init(); EXECUTE public.mc_delete(''mc_key''); RETURN NEW; END;' LANGUAGE 'plpgsql'; db=# CREATE FUNCTION schma.tbl_del() RETURNS TRIGGER AS 'BEGIN EXECUTE public.mc_init();

Re: [HACKERS] plpgsql lacks generic identifier for record in triggers...

2004-11-24 Thread Tom Lane
Sean Chittenden <[EMAIL PROTECTED]> writes: > ... Better yet, could TRIGGER functions be allowed to > return nothing (ala VOID)? > Which would tell the backend to assume that the row wasn't changed and > proceed with its handling. This is the preferred approach, IMHO... but > I think is the har

Re: [HACKERS] plpgsql lacks generic identifier for record in triggers...

2004-11-24 Thread Sean Chittenden
Now that pgmemcache is getting more use, I've heard a couple of groans regarding the need to have two functions with exactly the same code body. This is necessary because there is no generic way of handling NEW/OLD. For example: [snip] Err... wait, this is a classic case of send first then f