select test_variable_storage();

NOTICE: should see this

CONTEXT: SQL statement "SELECT trap_zero_divide(-100)"

NOTICE: should see this only if -100 <> 0

CONTEXT: SQL statement "SELECT trap_zero_divide(-100)"

NOTICE: should see this only if -100 fits in smallint

CONTEXT: SQL statement "SELECT trap_zero_divide(-100)"

test_variable_storage

-----------------------

123456789012

$$ language plpgsql;

select raise_test1(5);

ERROR: too many parameters specified for RAISE

create function raise_test2(int) returns int as $$

begin

raise notice 'This message has too few parameters: %, %, %', $1, $1;

$$ language plpgsql;

select raise_test2(10);

ERROR: too few parameters specified for RAISE

--

-- reject function definitions that contain malformed SQL queries at

-- compile-time, where possible

LINE 1: SELECT sqlstate

^

QUERY: SELECT sqlstate

create function excpt_test2() returns void as $$

begin

begin

LINE 1: SELECT sqlstate

^

QUERY: SELECT sqlstate

create function excpt_test3() returns void as $$

begin

begin

end$$ language plpgsql;

select footest();

ERROR: query returned no rows

create or replace function footest() returns void as $$

declare x record;

begin

end$$ language plpgsql;

select footest();

ERROR: query returned more than one row

drop function footest();

-- test scrollable cursor support

create function sc_test() returns setof integer as $$

select * from sc_test(); -- fails because of NO SCROLL specification

ERROR: cursor can only scan forward

HINT: Declare it with SCROLL option to enable backward scan.

create or replace function sc_test() returns setof integer as $$

declare

c refcursor;