Hello,
I get this error
#error 1
ERROR: syntax error at or near "," at character 525
LINE 15: FETCH curs INTO id, set_values;
^
from this function
drop function sx(varchar) ;
CREATE OR REPLACE FUNCTION sx( varchar ) RETURNS varchar AS $$
DECLARE
str_in ALIAS FOR $1;
id RECORD ;
set_values RECORD ;
curs CURSOR FOR SELECT id, set_values FROM constraint_table;
BEGIN
OPEN curs;
FETCH curs INTO id, set_values;
IF (str_in = set_values ) THEN RETURN 1::bit(2);
ELSE RETURN 0::bit(2);
END IF;
END;
$$ LANGUAGE plpgsql;
isn't it correct to declare as type RECORD ?
thanks,
joseph.
____________________________________________________________________________________
Have a burning question?
Go to www.Answers.yahoo.com and get answers from real people who know.