[HACKERS] passing a whole record variable into a SQL command is not implemented

[Gaetano Mendola]

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]