From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: Why so few built-in range types? |
Date: | 2011-11-30 18:08:44 |
Message-ID: | 1322676524.24279.22.camel@jdavis |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, 2011-11-29 at 12:01 -0500, Tom Lane wrote:
> One thing that bothered me while looking at the range types patch is
> that it seemed you'd been mighty conservative about creating built-in
> range types.
During development, I didn't want to juggle the OIDs for too many range
types. That was really the only reason.
> In particular, I don't understand why there's not a
> standard float8range type; that seems like a pretty common case.
> I'd have also expected to see a standard textrange type. What was
> the rationale for leaving these out?
A built-in textrange type would have to have collation "C", right? Do
you think that would be useful to enough people?
One that I'd like to see is an IP address type, but that's complicated
because inet and cidr support netmasks.
Regards,
Jeff Davis
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2011-11-30 18:20:18 | Re: Word-smithing doc changes |
Previous Message | Joe Abbate | 2011-11-30 17:36:27 | Re: Reserved words and delimited identifiers |