| Lists: | pgsql-admin |
|---|
| 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 |
| 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: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | ABBAS SHAKEEL <shakeel(dot)abbas(dot)qau(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: inet Operator Does not exists |
| Date: | 2010-05-09 00:44:15 |
| Message-ID: | 18127.1273365855@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg무지개 토토SQL |
ABBAS SHAKEEL <shakeel(dot)abbas(dot)qau(at)gmail(dot)com> writes:
> 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.
Per the 8.2 release notes:
* Add convenient arithmetic operations on INET/CIDR values (Stephen R. van den Berg)
The new operators are & (and), | (or), ~ (not), inet + int8, inet - int8, and inet - inet.
regards, tom lane