atttypmod encoding

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

Browse pgsql-general by date

  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