Re: CREATE TYPE - Mailing list pgsql-hackers

From
Subject Re: CREATE TYPE
Date
Msg-id 1078.219.65.236.165.1058550801.squirrel@mail.trade-india.com
Whole thread Raw
In response to CREATE TYPE  (Mike Aubury <mike@aubit.com>)
Responses Re: CREATE TYPE  (Mike Aubury <mike@aubit.com>)
List pgsql-hackers
Programmers Guide , Chap 10
http://www.postgresql.org/docs/7.3/static/xtypes.html

contrib/isbn_issn also provides an implementation example.

regds
mallah.

> Can someone point me at some detailed instructions for creating new
> datatypes..
>
> I've found quite a few web pages that mention it (in passing) and give
> brief  examples - but nothing much I can actually work with for my
> purposes..
>
> Ideally I'd like to use C as the language and the datatype will need an
>  'extent' (like 'char' can be char(10) - although its nothing like a
> char  field...)
>
> I'm targetting this at the new 7.4 - so I think i need to use 'version
> 1'  method (using Datum etc ?)
>
> Also - the datatype itself is a comlex type which stores half a dozen
> different integers (Its a modified datetime - storing the year, month,
> day,  hour, minute, second, but the extent gives it the ability to do
> YEAR TO DAY,  HOUR TO SECOND etc, so you only get/set the relevant
> sections).
> When 'selected' it would return a variable length string containing the
>  relevant data, and would be set by passing in a string (some of the
> data of  which may well be ignored if its outside the extent of the
> column etc)
>
> Hope thats enough - all pointers greatfully received..
> (and free'd when required :)
>
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 3: if posting/reading through
> Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly



-----------------------------------------
Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/




pgsql-hackers by date:

Previous
From: Mike Aubury
Date:
Subject: CREATE TYPE
Next
From: Robert Treat
Date:
Subject: Re: plpgsql strangeness with select into