Re: inet increment with int

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: andrew(at)supernews(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: inet increment with int
Date: 2005-09-07 12:35:59
Message-ID: 20050907123559.GC7193@quartz.itdept.newn.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Sep 07, 2005 at 02:48:00AM -0000, Andrew - Supernews wrote:
> On 2005-09-06, Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message James Robinson 2005-09-07 12:59:33
Previous Message Teodor Sigaev 2005-09-07 11:51:05 PL/PGSQL and drop/create table