Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> writes: > Just noticed something odd with a column of type "char". According to > the docs (and the way my old PG ran), the character data-type is > blank-padded. I'm not seeing that on one of my current machines (8.3.8) > or, perhaps I'm going blind on Friday. Was the definition of char changed? No; what you're forgetting is that length() doesn't count padding spaces in char(N) input. Try octet_length() if you want to be convinced that the spaces are there. Was your "old" PG pre-8.0? We changed that quite a long time ago. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
