>>>>> "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. Thanks for your help anyway. -- Laurent Martelli [EMAIL PROTECTED] Java Aspect Components http://www.aopsys.com/ http://jac.aopsys.com ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster