problem with overloading the "coalesce" function

Поиск
Список
Период
Сортировка
От Emil Rachovsky
Тема problem with overloading the "coalesce" function
Дата
Msg-id 20060306101812.89563.qmail@web54308.mail.yahoo.com
обсуждение исходный текст
Ответы Re: [GENERAL] problem with overloading the "coalesce" function  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Louie Loria
Дата:
Сообщение: Visual and PostgreSQL
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: [GENERAL] problem with overloading the "coalesce" function