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?


-----Original Message-----
[mailto:[EMAIL PROTECTED]] On Behalf Of Tom Lane
Sent: October 2, 2001 6:16 PM
Cc: 'Barry Lind'; [EMAIL PROTECTED]
Subject: Re: [JDBC] driver fails to handle strings in query statements

"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?

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to