"Shridhar" == Shridhar Daithankar <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
