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 :)



Fri, 18 Jul 2003 18:00:30 +0100
Mike Aubury <mike@aubit.com>
CREATE TYPE

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/



Fri, 18 Jul 2003 23:23:21 +0530 (IST)
<mallah@trade-india.com>
Re: CREATE TYPE
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@trade-india.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@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/
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend


Fri, 18 Jul 2003 19:55:29 +0100
Mike Aubury <mike@aubit.com>
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@trade-india.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@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/
>>
>>
>>
>> ---------------------------(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@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/



Sun, 20 Jul 2003 01:32:12 +0530 (IST)
<mallah@trade-india.com>
Re: CREATE TYPE