"Decibel!" <[EMAIL PROTECTED]> writes: > On Sep 3, 2007, at 7:26 AM, Gregory Stark wrote: >> Also, incidentally do you have a good reason to use CHAR instead of varchar >> or >> text? char(64) will take 64 bytes (actually 68 bytes in 8.2) even if you >> don't >> store anything more in it. text or varchar will take only as many bytes as >> the >> data you're storing (plus 4 bytes). > > Hrm, do we actually pad before storing? ISTM we should really do that the > other way around...
Yes we do. And it isn't really fixable either. The problem is the familiar old problem that in Postgres the typmod is not really part of the type and not always available when we need it to interpret the datum. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings