Re: [Pypgsql-users] money types, decimal module

[Gerhard H. <gh...@gh...>]

On Thu, Nov 18, 2004 at 02:54:31PM +1000, Timothy Smith wrote:
> Billy G. Allie wrote:
> [...] so i have float types ( becuase for various reasons thats what i'm
> forced to use) how do i pass them in? i understand the first part of
> what you are saying, if i pass string data in it will put it in
> correctly for any database type.

Use %s instead of %.2f as placeholder and you should be fine.

As Billy said, *always* use %s as placeholder when using pyPgSQL, no
matter what type the values are.

-- Gerhard