Re: length limitation in '=' operator when comparing TEXT fields ?

"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