Re: Join on incompatible types

Laurent Martelli wrote:

>>>>>>"Shridhar" == Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com> writes:
>
>
> [...]
>
> Shridhar> 2. Try following query EXPLAIN ANALYZE SELECT * from lists
> Shridhar> join classes on classes.id=lists.value where
> Shridhar> lists.id='16'::integer;
>
> Shridhar> classes.id=lists.value::integer.
>
> With classes.id of type integer and lists.value of type varchar, I get
> "ERROR: Cannot cast type character varying to integer", which is not
> such a surprise.

Try to_numbr function to get a number out of string. Then cast it to integer.

http://developer.postgresql.org/docs/postgres/functions-formatting.html

I hope that works. Don't have postgresql installation handy here..

Shridhar