| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Data types for IP address. |
| Date: | 2011-02-23 22:01:09 |
| Message-ID: | 4D6583A5.6040402@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 02/23/11 1:33 PM, Tom Lane wrote:
> The question is does he actually have a use-case for address ranges that
> don't correspond to legal CIDR ranges, but do nonetheless have an
> identifiable lower boundary, upper boundary, and no holes? And if so,
> what is it? The whole thing looked to me like somebody inventing
> requirements with little or no study of what they really needed.
indeed. i had to poke around the ban tables of MyBB the other day (a
php bbs that works reasonably well* on postgresql), and they were
storing IP bans as strings like 1.2.*.* or 1.2.3.4-1.2.4.5 or whatever.
UGH.
* it works mostly on PG but has some bugs around the edges of the admin
stuff. the worst ones I've found fixes for and submitted back to the
mybb team, but mostly I'm too lazy and just work around them
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kalai R | 2011-02-24 02:59:15 | PostgreSQL database design for a large company |
| Previous Message | Tom Lane | 2011-02-23 21:33:11 | Re: Data types for IP address. |