pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedoperating "inet" type
2+ messages / 2 participants
[nested] [flat]
* operating "inet" type
@ 2005-04-12 12:34 Ilya A. Kovalenko <shadow@oganer.net>
0 siblings, 1 reply; 2+ messages in thread
From: Ilya A. Kovalenko @ 2005-04-12 12:34 UTC (permalink / raw)
To: 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 (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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: operating "inet" type
@ 2005-04-13 13:14 Bruno Wolff III <bruno@wolff.to>
parent: Ilya A. Kovalenko <shadow@oganer.net>
0 siblings, 0 replies; 2+ messages in thread
From: Bruno Wolff III @ 2005-04-13 13:14 UTC (permalink / raw)
To: Ilya A. Kovalenko <shadow@oganer.net>; +Cc: pgsql-sql
On Tue, Apr 12, 2005 at 20:34:04 +0800,
"Ilya A. Kovalenko" <shadow@oganer.net> wrote:
>
> You can do integer compare two "inet" values, but you can't do
> integer increment (i.e. increment inet value by integer).
It would probably be useful to have some way of generating a list of
addresses in a subnet. Being able to increment addresses and having a
way to get the highest and lowest addresses in a subnet would give you
a way to do that.
> I understand, that developers has more important things to do, but
> they left "inet" type w/o any ways to work w/ it.
You can write your own functions to do this. It is possible that they
could go back into the code base if they seem generally useful.
If you are interested in getting them back into the code base, you are probably
best off proposing specs for the functions on the hackers lists for comments,
before writing them.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-04-13 13:14 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-12 12:34 operating "inet" type Ilya A. Kovalenko <shadow@oganer.net>
2005-04-13 13:14 ` Bruno Wolff III <bruno@wolff.to>
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