postgres=#
postgres=#
postgres=# CREATE FUNCTION somefunc() RETURNS integer AS $$
postgres$# DECLARE
postgres$# quantity integer := 30;
postgres$# BEGIN
postgres$# RAISE NOTICE 'Quantity here is %', quantity; -- Quantity here is 30
postgres$# quantity := 50;
postgres$# --
postgres$# -- Create a subblock
postgres$# --
postgres$# DECLARE
postgres$# quantity integer := 80;
postgres$# BEGIN
postgres$# RAISE NOTICE 'Quantity here is %', quantity; -- Quantity here is 80
postgres$# END;
postgres$#
postgres$# RAISE NOTICE 'Quantity here is %', quantity; -- Quantity here is 50
postgres$#
postgres$# RETURN quantity;
postgres$# END;
postgres$# $$ LANGUAGE plpgsql;
CREATE FUNCTION
postgres=#
postgres=# select somefunc();
NOTICE: Quantity here is 30
NOTICE: Quantity here is 80
NOTICE: Quantity here is 50
REATE
somefunc
----------
50
(1 row)
postgres=#
postgres=# drop function somefunc();
DROP FUNCTION
postgres=#
postgres=#