FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedMay 29, '04 at 12:21a
activeMay 29, '04 at 12:21a
posts1
users1
websitepostgresql.org...
irc#postgresql

1 user in discussion

Gaetano Mendola: 1 post

People

Translate

site design / logo © 2021 Grokbase