Ok, I need some sleep, now I see what it does, which is probably not what the user wanted, but I have fixed the driver to it doesn't throw an exception.
Dave -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dave Cramer Sent: October 2, 2001 9:12 PM To: 'Tom Lane' Cc: [EMAIL PROTECTED] Subject: Re: [JDBC] driver fails to handle strings in query statements properly As I said, I have no idea how the backend handles it when it is quoted. You mention that it's not a column reference, but it does get data from the id column? Dave -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Tom Lane Sent: October 2, 2001 6:16 PM To: [EMAIL PROTECTED] Cc: 'Barry Lind'; [EMAIL PROTECTED] Subject: Re: [JDBC] driver fails to handle strings in query statements properly "Dave Cramer" <[EMAIL PROTECTED]> writes: > I tried it on a table which id was an int > Using "select 'id' as xxx from ..." Returns xxx as an unknown type > Using "select id as xxx from... " returns xxx as an int I have no idea > how the backend handles this, but if it can figure it out in one > instance why can't it figure it out when I put single quotes around > it? Uh ... when you put single quotes around it, it's a literal, not a column reference ... and whatever one might think about 'id', it's certainly not an integer. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org