-- 
 -- PostgreSQL database dump 
 -- 

SET SESSION AUTHORIZATION 'pvic';

SET search_path = public, pg_catalog;

 -- 
 -- TOC entry 5 (OID 278716) 
 -- Name: plpgsql_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema: public; Owner: pvic 
 -- 

CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
    AS '$libdir/plpgsql', 'plpgsql_call_handler'
    LANGUAGE c;


SET SESSION AUTHORIZATION DEFAULT;

 -- 
 -- TOC entry 4 (OID 278717) 
 -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner: 
 -- 

CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;


SET SESSION AUTHORIZATION 'postgres';

 -- 
 -- TOC entry 3 (OID 2200) 
 -- Name: public; Type: ACL; Schema: -; Owner: postgres 
 -- 

REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;


SET SESSION AUTHORIZATION 'pvic';

SET check_function_bodies = false;

 -- 
 -- TOC entry 6 (OID 278718) 
 -- Name: somefunc(); Type: FUNCTION; Schema: public; Owner: pvic 
 -- 

CREATE FUNCTION somefunc() RETURNS integer
    AS '
DECLARE
    quantity integer := 30;
    BEGIN
        RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is 30
	    quantity := 50;
	        --
		    -- Create a subblock
		        --
			    DECLARE
			            quantity integer := 80;
				        BEGIN
					        RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is 80
						    END;
						    
						        RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is 50

							    RETURN quantity;
							    END;
							    '
    LANGUAGE plpgsql;


SET SESSION AUTHORIZATION 'postgres';

 -- 
 -- TOC entry 2 (OID 2200) 
 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres 
 -- 

COMMENT ON SCHEMA public IS 'Standard public schema';