Frank Miles <fpm@u.washington.edu> writes:
> A direct query gets appropriate rows of data:
> dbname=# select * from partdef where shpname = 'IDC16W';
> ...while the very same query (substituting LIKE for the '=' sign) gets nothing!?
Hm. Does EXPLAIN show the same kind of plan (index or seq scan) for
both queries? If not, does forcing the plan choice via ENABLE_xxxSCAN
make a difference? Do you have locale support turned on, and if so
what locale are you using?
regards, tom lane