Postgres Pro
Downloads
Home   >   mailing lists

Re: Implement a new data type - Mailing list pgsql-general

From Miles Elam
Subject Re: Implement a new data type
Date
Msg-id CAALojA__cLQag+VkvXr0CXq4fDiSyDziDjSCHNwk4Dt3VUQ3oA@mail.gmail.com
Whole thread Raw
In response to Re: Implement a new data type  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Implement a new data type  (raf <raf@raf.org>)
List pgsql-general
Tree view
Also of note: PostgreSQL already has a money type (https://www.postgresql.org/docs/current/datatype-money.html)

I only bring it up so that you can know to make your money type a slightly different name to avoid a conflict. Money is deceptively hard to implement correctly. I'd recommend reading the second link if you have not already to avoid previously known issues.


On Tue, Aug 11, 2020 at 5:02 AM Pavel Stehule <pavel.stehule@gmail.com> wrote:
Hi

út 11. 8. 2020 v 13:31 odesílatel mohand oubelkacem makhoukhene <mohand-oubelkacem@outlook.com> napsal:
Hello;
I whould like to implement a new data type next to char, number, varchar... A Money type.
So i'll have to change the source code, but i don't know which fonctions i need to change and which part to work on.
I need some help to implement this new data type.

If you need to implement just a new data type, then you don't need to modify Postgres source code. You can write your own extension.

For own custom type you need to write minimally "in" and "out" function, and then you can run "CREATE TYPE" statement

one example of custom type can be a extension https://github.com/okbob/pgDecimal

Regards

Pavel


Thank you and best regards
Mohand



pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Implement a new data type
Next
From: Adrian Klaver
Date:
Subject: Re: Implement a new data type