Обсуждение: Integrating New Data Type

Hi all,
I have defined a new data type. I have defined in and out function for that data type.
But i want to know how to integrate this data type with postgres (how postgres compile my code or know my datatype) ?

Thanks,
Nirmesh

Hello

2011/4/5 Nick Raj <nickrajjain@gmail.com>:
> Hi all,
> I have defined a new data type. I have defined in and out function for that
> data type.
> But i want to know how to integrate this data type with postgres (how
> postgres compile my code or know my datatype) ?

you have to register in, out functions, you have to register new type

look to postgresql sources - contrib, there is very simple type citext

http://doxygen.postgresql.org/dir_23dd6926f287bddac2c9dcb7db5b1712.html

http://doxygen.postgresql.org/citext_8c-source.html

Any contrib module has sql file with registrations

Regards

Pavel Stehule


>
> Thanks,
> Nirmesh
>

Pavel Stehule <pavel.stehule@gmail.com> Tuesday 05 April 2011 10:11:02
> Hello
>
> 2011/4/5 Nick Raj <nickrajjain@gmail.com>:
> > Hi all,
> > I have defined a new data type. I have defined in and out function for
> > that data type.
> > But i want to know how to integrate this data type with postgres (how
> > postgres compile my code or know my datatype) ?
>
> you have to register in, out functions, you have to register new type
>
> look to postgresql sources - contrib, there is very simple type citext
>
> http://doxygen.postgresql.org/dir_23dd6926f287bddac2c9dcb7db5b1712.html
>
> http://doxygen.postgresql.org/citext_8c-source.html
>
> Any contrib module has sql file with registrations
>
> Regards
>
> Pavel Stehule
>
> > Thanks,
> > Nirmesh

As well creating and registering new type is well documented - I think
somewhere about types and C procedures.
http://www.postgresql.org/docs/9.0/static/sql-createtype.html
http://www.postgresql.org/docs/9.0/static/xtypes.html
Regards,
Radek