public inbox for [email protected]  

help / color / mirror / Atom feed

From: Marcos Truchado <[email protected]>
To: [email protected]
Subject: error in plpgsql-statements.html#PLPGSQL-SELECT-INTO
Date: Mon, 24 Nov 2003 18:17:16 +0100
Message-ID: <[email protected]> (raw)

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.

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: error in plpgsql-statements.html#PLPGSQL-SELECT-INTO
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox