Re: insert column monetary type ver 2 - Mailing list pgsql-general

From vincent.veyron@libremen.org
Subject Re: insert column monetary type ver 2
Date
Msg-id 20211121164648.2f33e0dfc9f5b39438df9caa@libremen.org
Whole thread Raw
In response to Re: insert column monetary type ver 2  (Дмитрий Иванов <firstdismay@gmail.com>)
Responses Re: insert column monetary type ver 2
List pgsql-general
On Sat, 20 Nov 2021 19:32:54 +0500
Дмитрий Иванов <firstdismay@gmail.com> wrote:

> I saw it. I’m not tied down hard on this type. It's just that it exists and
> I decided to include it in my development. Thanks.
>


Consider storing integers; it's easy and fast, and all you need to do is display your numbers divided by 100, using
to_char(): 

select to_char(100001/100::numeric(10,2), '999G999D99');
   to_char
-------------
    1 000,01


--
https://marica.fr
Logiciel de gestion des contentieux juridiques, des contrats et des sinistres d'assurance
                    Bien à vous, Vincent Veyron



pgsql-general by date:

Previous
From: Дмитрий Иванов
Date:
Subject: Re: pg_dump insert column GENERATED
Next
From: Tom Lane
Date:
Subject: Re: pg_dump insert column GENERATED