Re: [BUGS] BUG #2108: Function with OUT parameters not recognized, using plpgsql

2005-12-12 Thread Alvaro Herrera
Tony wrote: > CREATE OR REPLACE FUNCTION f_multiparam ( > i1 integer, > i2 varchar, > OUT o1 varchar > ) AS > $$ > BEGIN > o1 := 'i2 was ' || i2; > END; > $$ > LANGUAGE plpgsql; > > CREATE OR REPLACE FUNCTION f_showperformstatus () RETURNS varchar AS > $$ > DECLARE > outparameter varcha

Re: [BUGS] BUG #2108: Function with OUT parameters not recognized, using plpgsql

2005-12-12 Thread Tom Lane
"Tony" <[EMAIL PROTECTED]> writes: > Defined a function with OUT paramter. Attempts to call it fail as the > function can not be found. Apparently, you don't understand how OUT parameters work either :-( Perhaps the examples here will help: http://www.postgresql.org/docs/8.1/static/xfunc-sql.html