Re: inet increment with int

Patrick Welche <prlw1@newn.cam.ac.uk>

From: Patrick Welche <prlw1@newn.cam.ac.uk>
To: andrew@supernews.com
Cc: pgsql-hackers@postgresql.org
Date: 2005-09-07T12:35:59Z
Lists: pgsql-hackers
On Wed, Sep 07, 2005 at 02:48:00AM -0000, Andrew - Supernews wrote:
> 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.

So, back to original version?

Comments anyone?

Patrick