problem with overloading the "coalesce" function - Mailing list pgsql-sql

From Emil Rachovsky
Subject problem with overloading the "coalesce" function
Date
Msg-id 20060306101812.89563.qmail@web54308.mail.yahoo.com
Whole thread Raw
Responses Re: [GENERAL] problem with overloading the "coalesce" function  (Richard Huxton <dev@archonet.com>)
List pgsql-sql

 Hi,
I am trying to overload the "coalesce" function to
accept an integer and a string. Here it is :

CREATE OR REPLACE FUNCTION "coalesce"(a int4, b
"varchar")
  RETURNS "varchar" AS
$BODY$
begin
 if (a is null ) then
   return b;
 else
  return cast(a as varchar(15));
end if;
end
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION "coalesce"(a int4, b "varchar") OWNER
TO postgres;

I have added it to pg_catalog, but still I cant't use
it, I get an error on the second parameter, apparently
the function gets lost at some point. Any additional
steps I need to complete?

Thanks in advance,
Emil

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-sql by date:

Previous
From: Michael Louie Loria
Date:
Subject: Visual and PostgreSQL
Next
From: Richard Huxton
Date:
Subject: Re: [GENERAL] problem with overloading the "coalesce" function