Re: CREATE TYPE - Mailing list pgsql-hackers

From
Subject Re: CREATE TYPE
Date
Msg-id 1192.219.65.252.228.1058644932.squirrel@mail.trade-india.com
Whole thread Raw
In response to Re: CREATE TYPE  (Mike Aubury <mike@aubit.com>)
List pgsql-hackers

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/




pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: dblink_ora - a first shot on Oracle ...
Next
From: Bruce Momjian
Date:
Subject: Re: dblink_ora - a first shot on Oracle ...