On Wednesday 2006-03-22 08:53, William ZHANG wrote:
> "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?
In or out of the standard, bitstring can be a nice type to have.