=?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 Postgres too, if you'd used varchar(n) rather than char(n) for string_id. As is, the trailing spaces in string_id are considered significant. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]