error in plpgsql-statements.html#PLPGSQL-SELECT-INTO
error in plpgsql-statements.html#PLPGSQL-SELECT-INTO
От:
Marcos Truchado <marcos@truchado.jazztel.es>
Дата:
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
full_name declared, but not used.
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.