| From: | Trent Shipley <tshipley(at)deru(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Modular Type Libraries: was A real currency type |
| Date: | 2006-03-23 00:39:12 |
| Message-ID: | 200603221739.15253.tshipley@deru.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Wednesday 2006-03-22 08:53, William ZHANG wrote:
> "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?
In or out of the standard, bitstring can be a nice type to have.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2006-03-23 00:47:26 | Re: index for inet and >> (contains) function |
| Previous Message | Alain BAUDHUIN | 2006-03-23 00:09:49 | substitute for array functions in postgresql v7.3 ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darcy Buskermolen | 2006-03-23 00:40:57 | Re: Accessing schema data in information schema |
| Previous Message | Kevin Grittner | 2006-03-23 00:09:09 | Where does the time go? |