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