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

Reply via email to