plpgsql overloading bug in 7.3.2 on OS X

From: Allie Micka <allie(at)pajunas(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: plpgsql overloading bug in 7.3.2 on OS X
Date: 2003-10-08 06:54:23
Message-ID: 3FF6DFAF-F95C-11D7-9C39-000A9575C7D6@pajunas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm having trouble overloading functions in plpgsql using PostgreSQL
7.3.2 on OS X.

I have created two functions with the following declarations:

CREATE OR REPLACE FUNCTION set_entity_type(BIGINT,TEXT) RETURNS BOOLEAN
AS ' ...
CREATE OR REPLACE FUNCTION set_entity_type(BIGINT,BIGINT) RETURNS
BOOLEAN AS ' ...

But it is not using the correct function:
SELECT set_entity_type(88,'Category');
ERROR: pg_atoi: error in "Category": can't parse "Category"

swm on #postgresql suggested enforcing the datatype in the function
call, as in 'Category'::text . This worked fine, but as I understand
it, this is still a bug.

Thanks!

Browse pgsql-hackers by date

  From Date Subject
Next Message Adrian Maier 2003-10-08 08:43:57 Re: Possible Commit Syntax Change for Improved TPS
Previous Message Allie Micka 2003-10-08 06:52:06 Possible Bug in 7.3.2 on OS X