| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: (7.1) BIT datatype |
| Date: | 2000-12-21 22:11:25 |
| Message-ID: | Pine.LNX.4.30.0012212306130.775-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Oliver Elphick writes:
> Some SQL92 functionality is missing from the BIT and VARBIT types.
>
> It should be possible to enter hexadecimal values as:
>
> B'[<bit>...]'[{<separator>...'[<bit...]'}...]
> X'[<hexdigit>...]'[{<separator>...'[<hexdigit...]'}...]
>
> (Cannan and Otten: SQL - The Standard Handbook, p.38)
>
> but the hexadeximal form is not accepted.
This was omitted because in SQL99 the X'1001' notation also serves as a
binary large object value under certain circumstances. Unfortunately,
it's not exactly known what those circumstances are.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2000-12-21 22:29:45 | Re: (7.1) BIT datatype |
| Previous Message | Oliver Elphick | 2000-12-21 21:33:51 | (7.1) BIT datatype |