Re: Join on incompatible types - Mailing list pgsql-performance

Laurent Martelli wrote:

>>>>>>"Shridhar" == Shridhar Daithankar <shridhar_daithankar@myrealbox.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