Hi!
I have following problem:
I have created a table with some fields, then I dropped last field (integer)
and added
one extra field (integer). Then I have created a function which returns
record of table
type. I have selected a record from table and returned it, but the values in
last
field are wrong (missing). It looks like that it takes the dropped field
instead of the last field.
Damjan
CREATE OR REPLACE FUNCTION damjan_test111(integer) RETURNS public.fk_test AS
'
DECLARE
rec fk_test%ROWTYPE;
siteid ALIAS FOR $1;
BEGIN
FOR rec IN SELECT * FROM public.fk_test WHERE
i = siteid LOOP
RETURN rec;
END LOOP;
END;
' LANGUAGE 'plpgsql';
