Re: Implement a new data type

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: mohand oubelkacem makhoukhene <mohand-oubelkacem(at)outlook(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Implement a new data type
Date: 2020-08-11 12:01:27
Message-ID: CAFj8pRCdxsrOmrxgm5ZaUA-EkDJat=ZHxeHst8uS0cBnuXCdLA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

út 11. 8. 2020 v 13:31 odesílatel mohand oubelkacem makhoukhene <
mohand-oubelkacem(at)outlook(dot)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
>
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Miles Elam 2020-08-11 13:38:39 Re: Implement a new data type
Previous Message Laurenz Albe 2020-08-11 12:00:04 Re: Implement a new data type