| From: | RW Shore <rws228(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | atttypmod encoding |
| Date: | 2011-02-09 13:03:49 |
| Message-ID: | AANLkTik_MU-Enu+LS0UiTaLuHja-v_AA_O91x1+Lt7qV@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Catalog pg_attribute contains interesting type-specific information in
attribute atttypmod. Can someone verify that these encodings are correct?
CHAR and VARCHAR: 4 + the declared length. Example: CHAR(5) -> 9 in
atttypmod
NUMERIC(p,s): 4 + the long with p in the left-most 4 bytes and s in the
right-most
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Gravsjö | 2011-02-09 14:08:40 | Re: Possible Bug |
| Previous Message | MOQUET Julien PP-DOSTL SDSIC DEPL | 2011-02-09 12:38:24 | Re: créer une DLL pour Postgresql 9 avec visual C++ [2008 |