Re: [DOCS] Unclear CHARACTER specification

2013-01-04 Thread Kevin Grittner
Lyle wrote: > Is there other documentation available that covers this? You might want to read this page: http://www.postgresql.org/docs/9.2/static/storage-toast.html Note that there is seldom a good reason to use char(n) in PostgreSQL for any value of n. As the page you cited mentions, "While c

[DOCS] Unclear CHARACTER specification

2012-12-30 Thread Lyle
Hi, Here: http://www.postgresql.org/docs/9.2/interactive/datatype-character.html There isn't really clear guidance on ranges and limits. All we have to go on is this paragraph: =start The storage requirement for a short string (up to 126 bytes) is 1 byte plus the actual string, which includ