"Nat!" <[EMAIL PROTECTED]> writes: > create temporary table foo ( nummer character(12) );
> insert into foo ( nummer) values( '1848' ) ; > select count(*) from foo where nummer = '1848' ; > -- returns 1 > select count(*) from foo where nummer like '1848' ; > -- returns 0 The trailing spaces are significant when doing LIKE on a char(n) column. regression=# select '1848'::character(12) like '1848'; ?column? ---------- f (1 row) regression=# select '1848'::character(12) like '1848 '; ?column? ---------- t (1 row) (By and large, my advice for all such cases is "don't use char(n)". It has no redeeming social value whatever.) regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs