Hello 2011/4/5 Nick Raj <nickrajjain@xxxxxxxxx>: > 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 > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general