Re: Confusion over Python drivers

>Andrew McNamara <andrewm(at)object-craft(dot)com(dot)au> writes:
>>>> The solution is to write the query in an unambiguous way:
>>>> SELECT $1::date + 1;
>
>> You are missing the point: this is not about what types the SQL execution
>> sees. It is about making sure the correct recv function is applied to
>> the binary parameter data.
>
>Indeed, and the above locution does set that.

Sure, but it requires the driver to modify the query - that isn't
reasonable or practical. Expecting the user to the driver to know
and correct set the type the driver will ultimately see is a recipe
for disaster.

--
Andrew McNamara, Senior Developer, Object Craft
http://www.object-craft.com.au/