Create a subblock : Code Block « Postgre SQL « PostgreSQL






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








Related examples in the same category

1.Two 'anyelement' parameters
2.SQL Functions Returning Sets