The following bug has been logged online:

Bug reference: 2643
Logged by: Gene Neely
Email address: paul.neely (AT) comcast (DOT) net
PostgreSQL version: 8.0.x 8.1.x
Operating system: Linux
Description: Auto trim on insert and update
Details:

THIS IS NOT A BUG, but a request. Found no place else to submit.
I have found no way to automatically trim fields to the length of the
varchar or char on inserts and updates.
I have tried to create check rules to trim to the varchar length with not
luck.
Can this become a Configuration option???
Doing trims of every variable at every sql command execution takes a lot of
time both coding and lookup the columns length.
Thanks.
Gene Neely

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

"Gene Neely" <paul.neely (AT) comcast (DOT) net> writes:
Write an explicit cast to varchar(N) or whatever it is.

No, because the behavior is required by the SQL standard.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org