| 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 |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2010-05-09 20:42:47 | List traffic |
| Previous Message | ABBAS SHAKEEL | 2010-05-08 18:56:43 | inet Operator Does not exists |