Hi, 
please run below recursion function in 7.1.3
-----------------------------------------------------------
drop function listTest(int4);
create function listTest(int4)
returns text
as 'declare
 mtype alias for $1;
 begin
  if mtype=0 then
  return ''0'';
  else
  return mtype||listTest(mtype-1);
  end if;
 end;'
language 'plpgsql';
select listTest(5);
--------------------------------------
response:

111110 (in 7.1.3, incorrenct!)

543210 (in 7.0.3, correct!)

Please tell me how to slove this problem if I don't want to go back to 7.0.3.

Thanks
Xiaoming 



*******************Internet Email Confidentiality Footer*******************
Privileged/Confidential Information may be contained in this message. If you
are not the addressee indicated in this message (or responsible for delivery of
the message to such person), you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender by
reply email. Please advise immediately if you or your employer does not consent
to Internet email for messages of this kind. Opinions, conclusions and other
information in this message that do not relate to the official business of my
firm shall be understood as neither given nor endorsed by it.







Hi, 
please run below recursion function in 
7.1.3
-----------------------------------------------------------
drop function listTest(int4);create function 
listTest(int4)returns textas 'declare mtype alias for 
$1; begin  if mtype=0 then  return 
''0'';  else  return 
mtype||listTest(mtype-1);  end if; end;'language 
'plpgsql';
select listTest(5);
--------------------------------------response:
 
111110 (in 7.1.3, incorrenct!)
 
543210 (in 7.0.3, correct!)
 
Please tell me how to slove this problem if I don't 
want to go back to 7.0.3.
 
Thanks
Xiaoming 
 
 
 
*******************Internet Email Confidentiality 
Footer*******************Privileged/Confidential Information may be 
contained in this message. If youare not the addressee indicated in this 
message (or responsible for delivery ofthe message to such person), you may 
not copy or deliver this message to anyone.In such case, you should destroy 
this message and kindly notify the sender byreply email. Please advise 
immediately if you or your employer does not consentto Internet email for 
messages of this kind. Opinions, conclusions and otherinformation in this 
message that do not relate to the official business of myfirm shall be 
understood as neither given nor endorsed by it.
Fri, 21 Sep 2001 17:35:47 +0800
"Zhang Xiaoming" <xiaoming.zhang@ebridgex.com>
bug! in 7.1.3 (for recursion function)