Mega Code Archive

Create a subblock

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=#