| From: | "William ZHANG" <uniware(at)zedware(dot)org> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Modular Type Libraries: was A real currency type |
| Date: | 2006-03-22 15:53:54 |
| Message-ID: | dvrs0j$r0u$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus | 2006-03-22 16:11:41 | Re: How to release locks |
| Previous Message | Tom Lane | 2006-03-22 15:47:02 | Re: How to release locks |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luke Lonergan | 2006-03-22 16:19:40 | Re: Automatically setting work_mem |
| Previous Message | Mark Wong | 2006-03-22 15:52:32 | Re: Patch Submission Guidelines |