Functon no longer supported. Why?

Поиск
Список
Период
Сортировка
От Kaloyan Iliev Iliev
Тема Functon no longer supported. Why?
Дата
Msg-id 4130954E.6080603@faith.digsys.bg
обсуждение исходный текст
Ответы Re: Functon no longer supported. Why?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello,
Could anyone explain why the following is no longer supported by default.
Now I have to write a function upper(inet).
I have a script which suddenly stop working after the upgrade:)))

I just want to know why:)
Kaloyan

template1=# select version();

version
---------------------------------------------------------------------------------------------------------
 PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2
(Mandrake Linux 10.0 3.3.2-6mdk)
(1 row)

template1=# select upper('193.68.13.6'::inet);
ERROR:  function upper(inet) does not exist
HINT:  No function matches the given name and argument types. You may
need to add explicit type casts.

=====================================================================
libvar=# select upper('193.68.13.6'::inet);
     upper
----------------
 193.68.13.6/32
(1 row)

libvar=# select version();
                            version
----------------------------------------------------------------
 PostgreSQL 7.2.3 on i386-pc-bsdi4.0.1, compiled by GCC 2.7.2.1
(1 row)


В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Poole
Дата:
Сообщение: Re: PSql won't Let me Set Varchar Column to 'true'
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Regression errors on beta1?