Postgres Pro
Downloads
Home   >   mailing lists

Re: 'currency' question; precision/decimal meaing - Mailing list pgsql-general

From Tom Lane
Subject Re: 'currency' question; precision/decimal meaing
Date
Msg-id 9455.974130241@sss.pgh.pa.us
Whole thread Raw
In response to Re: 'currency' question; precision/decimal meaing  (hubert depesz lubaczewski <depesz@depesz.pl>)
List pgsql-general
Tree view 
>> I want to store prices in a table. What's the best way to do this (since
>> 'money' is deprecated)?

Use type numeric, eg, numeric(12,2) if you want up to 12 digits total
with 2 of 'em after the decimal point (xxxxxxxxxx.xx).

            regards, tom lane

pgsql-general by date:

Previous
From:
Date:
Subject: Re: PHPBuilder article -- Postgres vs MySQL
Next
From: oberpwd@anubis.network.com (Wade D. Oberpriller)
Date:
Subject: PL/Perl