VARCHAR to CIDR type cast : external function for 6.5

From: Nicolas Huillard <nhuillard(at)ghs(dot)fr>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: VARCHAR to CIDR type cast : external function for 6.5
Date: 2001-06-13 23:12:57
Message-ID: 01C0F46F.2657A840.nhuillard@ghs.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

With the patch from Alex Pilosov (7.1), I was able to create external functions (6.5) to cast TEXT type to CIDR.
These function allow things like :
SELECT text_inet(text_field);
SELECT ... FROM ... WHERE text_cidr(text_field) >> '192.168.200.1'::inet;
...which are impossible with the current Postgres.
The code has greatly changed from 6.5 to 7.1, so these function might help users of older versions...
Extract the tarball, compile and install (tested on Linux/Postgres 6.5.3).

NH

Attachment Content-Type Size
network-10.tar.gz application/x-gzip 4.4 KB

Browse pgsql-general by date

  From Date Subject
Next Message Rob Arnold 2001-06-13 23:42:42 Re: abs() does not exists..
Previous Message David Wall 2001-06-13 22:55:21 Re: Vacuum analyze in 7.1.1