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