BUG #1608: integer negative limit in plpgsql function arguments

The following bug has been logged online:

Bug reference: 1608
Logged by: Paul
Email address: paul(at)allinea(dot)com
PostgreSQL version: 8.0.2
Operating system: Gentoo and Fedora Core 3
Description: integer negative limit in plpgsql function arguments
Details:

The script below best sums up the problem (and the work around). The
question is: should I use that for all integers being put into a function?

8<--------------------------------------------

create table test (
test_id integer
);

insert into test (test_id) values (-2147483648);

create function print_test_id (integer) returns integer
AS '
DECLARE
tmp ALIAS FOR $1;
val integer;
BEGIN
select into val test_id from test where test_id = tmp;
return val;
END;
'
LANGUAGE plpgsql;

-- this doesn't work (and I think it should!)
SELECT print_test_id(-2147483648);

-- this is the workaround
SELECT print_test_id((-2147483648)::int);

-------------------------------------------->8