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.




---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to