gistfile1.txt

postgres=# create table foo (a char(10), b varchar(10));
CREATE TABLE
postgres=# insert into foo(a) values ('foo   ');
INSERT 0 1
postgres=# select * from foo where a = 'foo';
     a      | b
------------+---
 foo        |
(1 row)

postgres=# select * from foo where a = 'foo ';
     a      | b
------------+---
 foo        |
(1 row)

postgres=# select * from foo where a = 'foo     ';
     a      | b
------------+---
 foo        |
(1 row)

postgres=# select * from foo where a = 'foo          ';
     a      | b
------------+---
 foo        |
(1 row)

postgres=# select * from foo where a = 'foo                          ';
     a      | b
------------+---
 foo        |
(1 row)

postgres=# insert into foo(b) values('foo  ');
INSERT 0 1
postgres=# select * from foo where b = 'foo';
 a | b
---+---
(0 rows)

postgres=# select * from foo where b = 'foo  ';
 a |   b
---+-------
   | foo
(1 row)

postgres=# insert into foo(b) values('foo jkjjjjjjjjjjjjjjjjjjjjjjjjj');
ERROR:  value too long for type character varying(10)

postgres=# insert into foo(b) values('foo                           a');
ERROR:  value too long for type character varying(10)

postgres=# insert into foo(b) values('foo                            ');
INSERT 0 1

# wait, what?