From: | "Damjan Pipan" <damjan(dot)pipan(at)siol(dot)net> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | problems with dropped columns |
Date: | 2003-01-28 13:36:25 |
Message-ID: | 014801c2c6d2$40caf5b0$c400a8c0@valhala |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general 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';
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Hihn | 2003-01-28 13:58:09 | Re: Using RSYNC for replication? |
Previous Message | Ron | 2003-01-28 13:19:55 | Re: list server problems? |
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2003-01-28 13:52:57 | Has everyone else here seen the "new" Database Open Test Suite by IBM? |
Previous Message | Ron | 2003-01-28 13:19:55 | Re: list server problems? |