operating "inet" type - Mailing list pgsql-sql

From Ilya A. Kovalenko
Subject operating "inet" type
Date
Msg-id 14038968283.20050412203404@oganer.net
Whole thread Raw
Responses Re: operating "inet" type
List pgsql-sql
Greetings,
 I'm confused, that PostgreSQL seems to don't have operators/functions
for examining/modifying "inet" data type. No any octet/word-based means
(like extract/replace), no even, trivial integer increments. No conversions, except conversion to symbolic string
(parsingit is
 
a mess and overhead). No even binary string conversions.
 You can do integer compare two "inet" values, but you can't do
integer increment (i.e. increment inet value by integer).
 I understand, that developers has more important things to do, but
they left "inet" type w/o any ways to work w/ it. Parsing "inet" converted text can't be, seriously, taken as
alternative,
but using numeric types to store addresses (and ignore native "inet"
type) really, can.
 I'm using PostgreSQL 7.4.3, Can 8.0.1 do more ?

Thank you.

Ilya A. Kovalenko    (mailto:shadow@oganer.net)
SpecialEQ SW section
JSC Oganer-Service 



pgsql-sql by date:

Previous
From: jspring@gmail.com
Date:
Subject: ignore single character in SELECT query?
Next
From: Ezequiel Tolnay
Date:
Subject: Re: Query runs very slowly in Postgres, but very fast in other DBMS