| From: | Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl> |
|---|---|
| To: | a(dot)maclean(at)cas(dot)edu(dot)au |
| Cc: | General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Single character bitfields |
| Date: | 2008-08-21 08:45:30 |
| Message-ID: | 48AD2B2A.3070205@batory.org.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2008-08-21 05:29, Andrew Maclean wrote:
> Is char(1) one byte in size?
No. It will also depend on database encoding, etc.
I think you should go with smallint, which is exactly 2 bytes. You'll
have 15 bits of storage (16 if you'd want to implement the special case
of minus sign).
IMHO the only smaller field are:
- one byte boolean, but it can only store 1 bit.
- one byte "char" (with quotes), but it is a non standard, integral
type, will cause interface problems and I don't know if it will not be
deprecated some time.
Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
Winnie the Pooh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shashwat_Nigam | 2008-08-21 08:53:51 | Re: Regarding access to a user |
| Previous Message | Tom Tom | 2008-08-21 08:22:52 | Re: pg_restore fails on Windows |