Functon no longer supported. Why?

Started by Kaloyan Iliev Ilievover 21 years ago2 messagesgeneral
Jump to latest
#1Kaloyan Iliev Iliev
news1@faith.digsys.bg

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)

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Kaloyan Iliev Iliev (#1)
Re: Functon no longer supported. Why?

Kaloyan Iliev Iliev <news1@faith.digsys.bg> writes:

Could anyone explain why the following is no longer supported by default.

Because we no longer will cast silently from inet to text.

regards, tom lane