On Wed, Aug 15, 2001 at 05:11:28PM -0700, Scott Holmes wrote:
> It would seem that my database has unseen garbage in the field being queried.
> On further testing I find that
>
> select *
> from people
> where peopcode LIKE 'AB%AH%'
> order by peopcode;
>
> works, however
>
> select *
> f
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
