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