From: Ilya A. Kovalenko <shadow@oganer.net>
To: pgsql-sql@postgresql.org
Subject: operating "inet" type
Date: Tue, 12 Apr 2005 20:34:04 +0800
Message-ID: <14038968283.20050412203404@oganer.net> (raw)
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 (parsing it 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: shadow@oganer.net
Subject: Re: operating "inet" type
In-Reply-To: <14038968283.20050412203404@oganer.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox