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
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 |