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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse psycopg by date

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