On Sep 18, 2004, at 1:09 PM, Oliver Jowett wrote:
Well, obviously. I haven't modified the backend code to accept 'unknown' in PREPARE..
Right, and that's what we're looking for.
My point was the client does *not* need to know the type inferred by the PREPARE in the 'unknown' case to make use of the resulting statement. It can pass all parameters as text and use the type inference that happens on EXECUTE -- as is happening in the EXECUTE quoted above.
Yes, that's fine, but it's PREPARE that's at issue here, not EXECUTE.
I think you misunderstand what I'm saying.
Tom reckons that PREPARE (at the SQL level) taking unknown types is not useful as there is no feedback mechanism along the lines of the V3 protocol Describe messages to let the client find out what types were inferred by the PREPARE.
I am saying this doesn't matter as the client can still use the resulting statement just fine without knowing the types. So allowing 'unknown' in PREPARE *is* useful.
Not that I'm volunteering to implement it, though -- the JDBC driver does not need this functionality and I'm way too short on time anyway :(
-O
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
