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
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 |