Re: Implement a new data type

[Miles Elam <miles.elam@xxxxxxxxxxxxxx>]

Also of note: PostgreSQL already has a money type (https://www.postgresql.org/docs/current/datatype-money.html)

But you shouldn't use it (https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use_money).

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@xxxxxxxxx> wrote:

Hi

út 11. 8. 2020 v 13:31 odesílatel mohand oubelkacem makhoukhene <mohand-oubelkacem@xxxxxxxxxxx> 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