FW: [GENERAL] problems with dropped columns

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Damjan Pipan
Sent: Tuesday, 28 January 2003 9:36 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] problems with dropped columns

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';

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org