Re: Syntax for wildcard selection

The field is, indeed, a char(17) field.  This particular database is actually
a copy of the same schema we use in our Informix applications.  The
definitions for that system were almost completely correct for creating the
PostgreSQL version, thus many fields are defined as char(x).  I shall try
redefining those fields that are of variable length as varchar() and see what
happens.

Thanks...

> The only thing I can think of is that you are using char() fields and the
> like is getting confused by the trailing spaces. Certainly putting wildcards
> anywhere in the string works fine.
>
> What is the data type of your column? text and varchar() wouldn't suffer
> from the above problem.
> --
> Martijn van Oosterhout <kleptog@svana.org>