Laurent Martelli wrote:

"Shridhar" == Shridhar Daithankar <[EMAIL PROTECTED]> writes:


  Shridhar> 2. Try following query EXPLAIN ANALYZE SELECT * from lists
  Shridhar> join classes on where


With 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.

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


---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

Reply via email to