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

Re: How to use the postgresql money type?

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: psycopg(at)postgresql(dot)org
Cc: Federico Di Gregorio <federico(dot)digregorio(at)dndg(dot)it>
Subject: Re: How to use the postgresql money type?
Date: 2011-01-20 15:58:19
Message-ID: 201101200758.19965.adrian.klaver@gmail.com (view raw or flat)
Thread:
Lists: psycopg
On Thursday 20 January 2011 7:45:30 am Federico Di Gregorio wrote:
> On 20/01/2011 16:40, A.M. wrote:

>
> But this makes sense. Do you mean that banker's rounding may depend on
> the locale? If that's the case and if PostgreSQL implements such
> gimmicks then the correct default for money would be to return it to
> Python as string and let the user decide how to proceed from there.
>
> federico

Info on the money type:
http://www.postgresql.org/docs/9.0/interactive/datatype-money.html

FYI this type at times has been marked as deprecated. There has been some recent 
work on it but it has issues especially, from the link above, the dump output 
and moving data to a different locale.

-- 
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

psycopg by date

Next:From: Carl S. Yestrau Jr.Date: 2011-01-23 07:53:23
Subject: getquoted and unicode
Previous:From: A.M.Date: 2011-01-20 15:50:16
Subject: Re: How to use the postgresql money type?

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