sql-ledger-users

[SL] Currency Field Type

[Les R <ope...@gm...>]

Hi,

What kind of SQL field type is used to store currency values in Sql-Ledger?

Thanks,

Les Richardson
Open Admin for Schools

Re: [SL] Currency Field Type

[Seneca C. <te...@gm...>]

On Tue, Jan 09, 2007 at 08:57:33AM -0600, Les R wrote:
> What kind of SQL field type is used to store currency values in Sql-Ledger?

float or float8.  Check sql/Pg-tables.sql to confirm if you wish.

-- 
Seneca
te...@gm...

Re: [SL] Currency Field Type

[Wallace R. C. <wrc...@gm...>]

On 1/9/07, Les R <ope...@gm...> wrote:
> Hi,
>
> What kind of SQL field type is used to store currency values in Sql-Ledger?

=> \d acc_trans
                    Table "public.acc_trans"
     Column     |       Type       |          Modifiers
----------------+------------------+-----------------------------
 trans_id       | integer          |
 chart_id       | integer          |
 amount         | double precision |
 transdate      | date             | default ('now'::text)::date
 source         | text             |
 cleared        | boolean          | default false
 fx_transaction | boolean          | default false
 project_id     | integer          |

-- 
Best Regards,
Wallace