Marcos Truchado <[EMAIL PROTECTED]> reported this on -docs yesterday.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Index: plpgsql.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/plpgsql.sgml,v
retrieving revision 1.29
diff -c -r1.29 plpgsql.sgml
*** plpgsql.sgml 12 Nov 2003 22:47:47 -0000 1.29
--- plpgsql.sgml 25 Nov 2003 14:12:50 -0000
***************
*** 986,994 ****
<programlisting>
DECLARE
users_rec RECORD;
- full_name varchar;
BEGIN
! SELECT INTO users_rec * FROM users WHERE user_id=3;
IF users_rec.homepage IS NULL THEN
-- user entered no homepage, return "http://"
--- 986,993 ----
<programlisting>
DECLARE
users_rec RECORD;
BEGIN
! SELECT * FROM users WHERE user_id=3 INTO users_rec;
IF users_rec.homepage IS NULL THEN
-- user entered no homepage, return "http://"
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster