The following bug has been logged online:
Bug reference: 3771
Logged by: Oliver Artelt
Email address: [EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
