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.steh...@gmail.com> wrote: > Hi > > út 11. 8. 2020 v 13:31 odesílatel mohand oubelkacem makhoukhene < > mohand-oubelka...@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 >> >> >> >>
