From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | passing a whole record variable into a SQL command is not implemented |
Date: | 2004-05-28 23:59:03 |
Message-ID: | c98joa$4mi$1@floppy.pyrenet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi all,
I'm running our regression test on top of postgresql 7.5 devel.
I found this function not working anymore ( is a distillated ):
create table test ( quota integer );
CREATE OR REPLACE FUNCTION sp_test ( )
RETURNS TEXT AS'
DECLARE
quota RECORD;
my_ret TEXT := '''';
BEGIN
FOR quota IN
SELECT quota
FROM test
LOOP
my_ret := my_ret || quota.quota || '','';
END LOOP;
RETURN my_ret;
END;
' LANGUAGE 'plpgsql'
WITH ( iscachable );
when I execute it I obtain:
ERROR: passing a whole record variable into a SQL command is not
implemented
the problem is that the variable quota have the same column name
for the table test, for us it's a minimum issue due the fact that
is easily fixed changing the variable name, but I'm wondering if
behind there is something wrong.
Regards
Gaetano Mendola
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Gardner | 2004-05-29 00:13:28 | Re: Extended customizing, SQL functions, |
Previous Message | Dann Corbit | 2004-05-28 23:14:50 | Re: -Wall and Wmissing-prototype |