Re: [BUGS] Bug in LIKE operator processing

2003-01-28 Thread Tom Lane
=?iso-8859-2?Q?=AFak=2C_S=B3awomir?= <[EMAIL PROTECTED]> writes: > I've found that statement: > SELECT * FROM os WHERE 'FreeBSD 4.7-RC' > LIKE string_id; (one of string_id's is 'FreeBSD 4.7%') > doesn't work. No error is reported. It does work in Oracle, It'd probably work in

Re: [BUGS] Bug in LIKE operator processing

2003-01-28 Thread Stephan Szabo
On Mon, 27 Jan 2003, [iso-8859-2] ¯ak, S³awomir wrote: > I've found that statement: > > SELECT * FROM os WHERE 'FreeBSD 4.7-RC' > LIKE string_id; (one of string_id's is 'FreeBSD 4.7%') > string_id | character(32) | character(32) has space padding which is probably g

[BUGS] Bug in LIKE operator processing

2003-01-28 Thread Żak, Sławomir
I've found that statement: SELECT * FROM os WHERE 'FreeBSD 4.7-RC' LIKE string_id; (one of string_id's is 'FreeBSD 4.7%') doesn't work. No error is reported. It does work in Oracle, so I think it's a standard SQL query. Table is defined as: host=> \d os