error in plpgsql-statements.html#PLPGSQL-SELECT-INTO

From: Marcos Truchado <mtruchado(at)telefonica(dot)net>
To: pgsql-docs(at)postgresql(dot)org
Subject: error in plpgsql-statements.html#PLPGSQL-SELECT-INTO
Date: 2003-11-24 17:17:16
Message-ID: 3FC23D1C.4030601@telefonica.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi. I have just learned how to create my own triggers on plpgsql
language, and I think I have discover an error into the doc:

http://www.postgresql.org/docs/current/static/plpgsql-statements.html#PLPGSQL-SELECT-INTO
------------------------------------------------------------------------

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://"
RETURN ''http://'';
END IF;
END;

------------------------------------------------------------------------
full_name declared, but not used.

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2003-11-24 19:20:51 DocBook V4.2, on the way to XML
Previous Message Marcos Truchado 2003-11-24 16:02:56 error in plpgsql-statements.html#PLPGSQL-SELECT-INTO