[PATCHES] Clarify use of NOW() in pl/pgsql docs

[David Fetter]

Folks,

This one from Ben Calvert.  It uses the (imho clearer) NOW() rather
than 'NOW' in a PL/PgSQL function example.

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.58
diff -c -r1.58 plpgsql.sgml
*** doc/src/sgml/plpgsql.sgml   22 Jan 2005 22:56:36 -0000      1.58
--- doc/src/sgml/plpgsql.sgml   27 Jan 2005 10:24:42 -0000
***************
*** 2602,2608 ****
          END IF;
  
          -- Remember who changed the payroll when
!         NEW.last_date := 'now';
          NEW.last_user := current_user;
          RETURN NEW;
      END;
--- 2602,2608 ----
          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: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq