Re: [HACKERS] Definitional issue for INET types

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sevo(at)ip23(dot)net
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Definitional issue for INET types
Date: 2000-02-17 15:49:19
Message-ID: 15690.950802559@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Sevo Stille <sevo(at)ip23(dot)net> writes:
> I'll see whether I can figure out something consistent for the inet data
> type. As it is right now, we might just as well drop it - it is both
> synonymous to cidr and to a cidr /32 host, which simply can't be.
> Personally, I don't think we would lose any functionality if we drop it,
> as long as we have functions that return classed network structures like
> the base address and a networks subnettable range.

Hmm. One way to throw the question into stark relief is to ask:
Is '10/8' *equal to* '10.0.0.0/32', in the sense that unique indexes
and operations like SELECT DISTINCT should consider them identical?
Does your answer differ depending on whether you assume the values
are of CIDR or INET type?

Once we have decided if they are equal or not, we can certainly manage
to come up with a sort ordering for the cases that are not equal.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-02-17 15:57:37 Re: [HACKERS] Almost there on column aliases
Previous Message Tom Lane 2000-02-17 15:41:38 Re: [HACKERS] Definitional issue for INET types