"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
The following bug has been logged online:
Bug reference: 4574
Logged by: Nat!
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.5
Operating system: Mac OS X 10.4
Description:LIKE fails on non-varying character with no wildcards
Details:
The documentation clai