Hi,
Why do I get the message in Subject when I do 'select proc_sub_b()'
under psql ? If I comment out the RAISE statement in proc_sub_a then I
don't see the message.
Thanks,
Gary
int_admin.modaps_int> select proc_sub_b();
INFO: id=11
CONTEXT: PL/pgSQL function "proc_sub_b" line 7 at assignment
proc_sub_b
------------
0
(1 row)
------------------------------------------------------------
CREATE OR REPLACE FUNCTION proc_sub_a(
v_id int
) RETURNS INTEGER AS $$
DECLARE
BEGIN
RAISE INFO 'id=%', v_id;
return 1;
end;
$$ LANGUAGE plpgsql;
CREATE OR REPLACE FUNCTION proc_sub_b(
) RETURNS INTEGER AS $$
DECLARE
v_ret int;
BEGIN
v_ret := proc_sub_a(11);
return 0;
end;
$$ LANGUAGE plpgsql;