Re: Implement a new data type

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