Thread: bug! in 7.1.3 (for recursion function)

Hi,=20
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=3D0 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=20



*******************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 deliver=
y of
the message to such person), you may not copy or deliver this message to an=
yone.
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 con=
sent
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.

"Zhang Xiaoming" <xiaoming.zhang@ebridgex.com> writes:
> please run below recursion function in 7.1.3

This is fixed in current sources (7.2-to-be).

            regards, tom lane