Re: Differences in WHERE clause of SELECT

Prabakaran,


> I am a newbie to PostgreSQL and was wondering about the following
> behaviour.

pgsql-hackers is not the appropriate list for this kind of question.  In
the future, please post to pgsql-novice, pgsql-sql, or pgsql-general
with this kind of question.  Thanks.

> Can you please help me understand why 'LIKE' does not use implicit cast
> ? 

Like uses the operator class "text_pattern_ops" which doesn't include an
implict cast.  For one thing, the implicit cast is from text -->
integer, not the other way around, and there is no LIKE operator for
integers.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com