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

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.