Re: CREATE TYPE

sorry i was not the rite person to answer
at the first place.
wait for other hacker to help ya.

regds
mallah.

> OK - i've got the basic input/output working now - but how to I do the
> extent bit ?
> eg. allow :
>
> create table (
> something a4gl_datime(15)
> )
>
>
> On Friday 18 July 2003 6:53 pm, mallah(at)trade-india(dot)com wrote:
>> 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(at)postgresql(dot)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/
>>
>>
>>
>> ---------------------------(end of
>> broadcast)--------------------------- TIP 8: explain analyze is your
>> friend
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 3: if posting/reading through
> Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)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/