"Kevin J. Grittner" <[EMAIL PROTECTED]> writes:
> The column searched with the LIKE predicate must be defined with a domain.
> Things work fine until ANALYZE or VACUUM ANALYZE is run against the table.
Fixed for 8.0.4. Here is the patch if you need it immediately.
regard
"Kevin J. Grittner" <[EMAIL PROTECTED]> writes:
> postgres=# select * from t1 where f2 like 't%';
> ERROR: unsupported type: 32740963
Confirmed in CVS tip --- looks like we missed a case where we need to
flatten out a domain. Thanks for the report!
regards, tom lane
---
The following bug has been logged online:
Bug reference: 1694
Logged by: Kevin J. Grittner
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Both Windows 2000 and Linux
Description:LIKE fails on column with domain after ANALYZE
Details:
I
