Re: inet increment with int

Andrew - Supernews <andrew+nonews@supernews.com>

From: Andrew - Supernews <andrew+nonews@supernews.com>
To: pgsql-hackers@postgresql.org
Date: 2005-09-07T02:48:00Z
Lists: pgsql-hackers
On 2005-09-06, Patrick Welche <prlw1@newn.cam.ac.uk> wrote:
> Now with:
>
> test=# select '192.168.0.0/24'::inet + 1;
> ERROR:  Trying to increment a network (192.168.0.0/24) rather than a host

What possible justification is there for this behaviour?

> test=# select '192.168.0.1/24'::inet + -1;
> ERROR:  Increment returns a network (192.168.0.0/24) rather than a host

While I suspect I know where this idea came from, it is equally boneheaded
since it is making completely unwarranted assumptions about how inet
values are being used.

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services