Re: Modular Type Libraries: was A real currency type - Mailing list pgsql-hackers

From William ZHANG
Subject Re: Modular Type Libraries: was A real currency type
Date
Msg-id dvrs0j$r0u$1@news.hub.org
Whole thread Raw
In response to Modular Type Libraries: was A real currency type  (Trent Shipley <tshipley@deru.com>)
Responses Re: Modular Type Libraries: was A real currency type  (Trent Shipley <tshipley@deru.com>)
List pgsql-hackers
"Tom Lane" <tgl@sss.pgh.pa.us>
> 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 clue
> us in).

There is a standard data type called "BIT" in ODBC and JDBC,
but it is sth. like SQL standard's BOOLEAN, not BIT. It seems that
some DBMSs implement BIT as BOOLEAN in the backend. Maybe the standard
committee think that bit string is useless and easy to cause confusion?

Regards,
William ZHANG




pgsql-hackers by date:

Previous
From: Mark Wong
Date:
Subject: Re: Patch Submission Guidelines
Next
From: "Luke Lonergan"
Date:
Subject: Re: Automatically setting work_mem