inet Operator Does not exists

From: ABBAS SHAKEEL <shakeel(dot)abbas(dot)qau(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: inet Operator Does not exists
Date: 2010-05-08 18:56:43
Message-ID: AANLkTilf13Vk_bnulsFUqJPU0_w1tXUoEh-bHnEiuDSG@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Team,

I am facing an issue with inet .

Locally i am using postgresql 8.3 and for remote server i am using 8.1

CREATE FUNCTION inet_to_bigint(inet) RETURNS bigint AS $$
SELECT $1 - inet '0.0.0.0'
$$ LANGUAGE SQL;

Now above querry works fine for 8.3 but not for 8.1. I was wondering if
there is some thing wrong from my side.

Below is the error message

ERROR: operator does not exist: inet - inet
HINT: No operator matches the given name and argument type(s). You
may need to add explicit type casts.
CONTEXT: SQL function "inet_to_bigint"

--
Best Regards
Shakeel Abbas

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-05-09 00:44:15 Re: inet Operator Does not exists
Previous Message Paulo moraes 2010-05-08 16:32:55 Invitation to connect on LinkedIn