"Michael Beckstette" <mbeckste@TechFak.Uni-Bielefeld.DE> writes:
> i have a little problem when selecting entries from a table, specified by a
> long match on a field of type TEXT. Is there a length limitation for the '='
> operator when comparing a field of type TEXT to a given string ?
No.
> Example:
> SELECT description FROM sequences_33 WHERE description LIKE 'gi 17559974%';
^^^^^^^^^^^^^^^^^^^
> [ finds a row ]
> SELECT description FROM sequences_33 WHERE description=' gi 17559974 ref
^^^^^^^^^^^^^^^^^
> [ finds no row ]
You seem to think that leading spaces are insignificant. They are not.
regards, tom lane
