Re: Confusion over Python drivers - Mailing list pgsql-hackers

From Andrew McNamara
Subject Re: Confusion over Python drivers
Date
Msg-id 20100213010743.16C5B206F7@longblack.object-craft.com.au
Whole thread Raw
In response to Re: Confusion over Python drivers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>Andrew McNamara <andrewm@object-craft.com.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/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Writeable CTEs and empty relations
Next
From: Alex Hunsaker
Date:
Subject: Re: Package namespace and Safe init cleanup for plperl [PATCH]