BUG #3771: function pg_catalog.btrim(numeric, unknown) does not exist

The following bug has been logged online:

Bug reference:      3771
Logged by:          Oliver Artelt
Email address:      oli@cubeoffice.de
PostgreSQL version: 8.3-beta2
Operating system:   Win XP, SP 2, 32b
Description:        function pg_catalog.btrim(numeric, unknown) does not
exist
Details:

definition:

CREATE OR REPLACE FUNCTION saufschlagreihe(integer, smallint)
  RETURNS text AS
$BODY$
DECLARE

    LEID    ALIAS FOR $1;
    iFormat ALIAS FOR $2;

    sResult text;
    s       text;
    r       record;
    d       numeric;

BEGIN

    s := 'SELECT AufschlagNameKurz,AufschlagProz,AufschlagZeit FROM
tblAufschlag INNER JOIN tblAufschlagTyp ON Key_AufschlagTyp =
ID_AufschlagTyp WHERE Key_LE = ' || LEID;
    sResult = '';

    FOR r IN EXECUTE s LOOP


        ---------
        --Kurzbez
        ---------
        if iFormat = 0 then

            sResult := sResult || ', ' || r.AufschlagNameKurz;

        ------------------
        --Kurzbez, Prozent
        ------------------
        elsif iFormat = 1 then

            sResult := sResult || ', ' || r.AufschlagNameKurz || ' (' ||
r.AufschlagProz || '%)';

        -----------------------------
        --Kurzbez, Zeitdauer, Prozent
        -----------------------------
        else

            d := r.AufschlagZeit;
            If d > 0 Then

                sResult := sResult || ', ' || r.AufschlagNameKurz || ' (';
                if d / 60 = (d / 60)::int4 then
                    sResult := sResult || trim(to_char(d / 60, '990'));
                else
                    sResult := sResult || trim(to_char(d / 60, '990.00'));
                end if;
                sResult := sResult || 'h * ' || trim(both '0' from
r.AufschlagProz) || '%)';

            End If;
        end If;

    end Loop;


    return trim(overlay(sResult placing '  ' from 1));

END;
$BODY$
  LANGUAGE 'plpgsql' STABLE
  COST 100;


call:


select saufschlagreihe(69128, 2::smallint);


msg:



ERROR:  function pg_catalog.btrim(numeric, unknown) does not exist
LINE 1: SELECT   $1  || 'h * ' || trim(both '0' from  $2 ) || '%)'
                                  ^
HINT:  No function matches the given name and argument types. You might need
to add explicit type casts.
QUERY:  SELECT   $1  || 'h * ' || trim(both '0' from  $2 ) || '%)'
CONTEXT:  PL/pgSQL function "saufschlagreihe" line 47 at assignment

********** Fehler **********

ERROR: function pg_catalog.btrim(numeric, unknown) does not exist
SQL Status:42883
Hinweis:No function matches the given name and argument types. You might
need to add explicit type casts.
Kontext:PL/pgSQL function "saufschlagreihe" line 47 at assignment



works on 8.2.4 and older



regards, oli