Re: [HACKERS] Modular Type Libraries: was A real currency type

2006-03-22 Thread Martijn van Oosterhout
On Tue, Mar 21, 2006 at 10:39:03PM -0500, Tom Lane wrote: AFAICS, the main part of the type system that isn't modular is the support for type parameters (a/k/a typmod), such as the maximum length for varchar or the precision/scale for numeric. We could certainly invent an API for interpreting

Re: [HACKERS] Modular Type Libraries: was A real currency type

2006-03-22 Thread William ZHANG
Tom Lane [EMAIL PROTECTED] Timestamps and numerics are definitely in the spec, geometric and network types are definitely not. IIRC, bitstring types are in SQL99 but for some reason are deprecated in SQL2003 (if anyone knows the reasoning behind the SQL committee's about-face on that, please

Re: [HACKERS] Modular Type Libraries: was A real currency type

2006-03-22 Thread Trent Shipley
On Wednesday 2006-03-22 08:53, William ZHANG wrote: Tom Lane [EMAIL PROTECTED] Timestamps and numerics are definitely in the spec, geometric and network types are definitely not. IIRC, bitstring types are in SQL99 but for some reason are deprecated in SQL2003 (if anyone knows the

[HACKERS] Modular Type Libraries: was A real currency type

2006-03-21 Thread Trent Shipley
Without directly addressing the merits of enumerations, enumeration interfaces, real currency and time zone types, or whether currency and time zone types should be built using enumerations, I would like to ask the powers-that-be to seriously consider radically modularizing Postgresql's type

Re: [HACKERS] Modular Type Libraries: was A real currency type

2006-03-21 Thread Andrew Dunstan
Trent Shipley said: Without directly addressing the merits of enumerations, enumeration interfaces, real currency and time zone types, or whether currency and time zone types should be built using enumerations, I would like to ask the powers-that-be to seriously consider radically

Re: [HACKERS] Modular Type Libraries: was A real currency type

2006-03-21 Thread Tom Lane
Trent Shipley [EMAIL PROTECTED] writes: Without directly addressing the merits of enumerations, enumeration interfaces, real currency and time zone types, or whether currency and time zone types should be built using enumerations, I would like to ask the powers-that-be to seriously consider

Re: [HACKERS] Modular Type Libraries: was A real currency type

2006-03-21 Thread Aftab Alam
remove my email from the list Regards, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew Dunstan Sent: Wednesday, March 22, 2006 9:05 AM To: [EMAIL PROTECTED] Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Modular Type Libraries

Re: [HACKERS] Modular Type Libraries: was A real currency type

2006-03-21 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: ... The real issue is what types and type mechanisms should be in the postgresql core distribution. We won't win any thanks from anyone if we reduce them. Getting some types right is hard. There is no case that I can see for pushing timestamps,