Postgres Pro
Downloads
Home   >   mailing lists

Re: Differences in WHERE clause of SELECT - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Differences in WHERE clause of SELECT
Date
Msg-id 51DC98E5.1020506@agliodbs.com
Whole thread Raw
In response to Differences in WHERE clause of SELECT  ("Prabakaran, Vaishnavi" <vaishnavip@fast.au.fujitsu.com>)
Responses Re: Differences in WHERE clause of SELECT
Re: Differences in WHERE clause of SELECT
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: "Prabakaran, Vaishnavi"
Date:
Subject: Differences in WHERE clause of SELECT
Next
From: Josh Berkus
Date:
Subject: Re: Changing recovery.conf parameters into GUCs