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 t

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,

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 interpret

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

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: was A

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 con

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 modular