At 12:12 AM 7/31/04, mike g wrote:
>Varchar will automatically trim any unused positions.
varchar doesn't 'trim' anything - it inserts text exactly as it is coded.
fbax=# create table vctest( c1 varchar );
CREATE
fbax=# insert into vctest values('abc ');
INSERT 11939819 1
fbax=# insert into vctest values('abcd');
INSERT 11939820 1
fbax=# select *,length(c1) from vctest where c1~' $';
c1 | length
--------+--------
abc | 6
(1 row)