Richard Huxton <dev@xxxxxxxxxxxx> writes: > Dmitry Teslenko wrote: >> When <operator> is LIKE no records matches query, when <operator> is = >> my record matches query. Why? And Does this behavior varies from >> PostgreSQL 7.4 to 8.1? > You're comparing a 3-character value '111' of type text to a > 10-character one (whatever is in field1). That's probably not a sensible > thing to do. You haven't got '111' as a value, you've got '111' with 7 > trailing spaces. Search for that and you'll find it. Better yet: use varchar(n) not character(n). character(n) has no redeeming social value whatsoever. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
