problems with dropped columns
Damjan Pipan <damjan.pipan@siol.net>
From: "Damjan Pipan" <damjan.pipan@siol.net>
To: <pgsql-general@postgresql.org>
Date: 2003-01-28T13:36:25Z
Lists: pgsql-hackers
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';