Folks, Please find enclosed a patch that fixes the trigger example in plpgsql (emp_stamp).
Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote!
Index: doc/src/sgml/plpgsql.sgml =================================================================== RCS file: /projects/cvsroot/pgsql/doc/src/sgml/plpgsql.sgml,v retrieving revision 1.57.4.2 diff -c -r1.57.4.2 plpgsql.sgml *** doc/src/sgml/plpgsql.sgml 6 Oct 2005 21:21:27 -0000 1.57.4.2 --- doc/src/sgml/plpgsql.sgml 20 Oct 2005 23:37:28 -0000 *************** *** 2640,2646 **** END IF; -- Remember who changed the payroll when ! NEW.last_date := 'now'; NEW.last_user := current_user; RETURN NEW; END; --- 2640,2646 ---- END IF; -- Remember who changed the payroll when ! NEW.last_date := now(); NEW.last_user := current_user; RETURN NEW; END;
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings