Functon no longer supported. Why?

From: Kaloyan Iliev Iliev <news1(at)faith(dot)digsys(dot)bg>
To: pgsql-general(at)postgresql(dot)org
Subject: Functon no longer supported. Why?
Date: 2004-08-28 14:23:10
Message-ID: 4130954E.6080603@faith.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-08-28 16:10:05 Re: Regression errors on beta1?
Previous Message Richard Poole 2004-08-28 09:54:09 Re: PSql won't Let me Set Varchar Column to 'true'