Re: Integrating New Data Type

From: Radosław Smogura <rsmogura(at)softperience(dot)eu>
To: pgsql-general(at)postgresql(dot)org
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Nick Raj <nickrajjain(at)gmail(dot)com>
Subject: Re: Integrating New Data Type
Date: 2011-04-06 20:01:06
Message-ID: 201104062201.06631.rsmogura@softperience.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> Tuesday 05 April 2011 10:11:02
> Hello
>
> 2011/4/5 Nick Raj <nickrajjain(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Curvey 2011-04-06 20:02:25 Re: postgres segfaulting on pg_restore
Previous Message Rich Shepard 2011-04-06 19:34:43 Postgres-9.x - ADODB - PHP