Skip site navigation (1) Skip section navigation (2)

Re: Confusion over Python drivers

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew McNamara <andrewm(at)object-craft(dot)com(dot)au>
Cc: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Confusion over Python drivers
Date: 2010-02-12 14:31:27
Message-ID: 25211.1265985087@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2010-02-12 14:34:29
Subject: Re: Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL
Previous:From: Andrew DunstanDate: 2010-02-12 13:56:48
Subject: Re: Add on_trusted_init and on_untrusted_init to plperl UPDATED [PATCH]

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group