Re: composite data type question

Jessica M Salmon <jmsalmon@xxxxxxxxx> · Wed, 7 Jun 2006 09:37:10 -0600

Thanks Michael.
I suppose I will have to find another way to represent the data, yes.
We are tracking fire progress across a landscape, based on processing of
MODIS (http://modis.gsfc.nasa.gov/) data.
Thanks again,
Meghan

             Michael Fuhr                                                  
             <mike@xxxxxxxx>                                               
                                                                        To 
             06/07/2006 07:59          Jessica M Salmon                    
             AM                        <jmsalmon@xxxxxxxxx>                
                                                                        cc 
                                       pgsql-general@xxxxxxxxxxxxxx        
                                                                   Subject 
                                       Re: [GENERAL] composite data type   
                                       question                            

On Tue, Jun 06, 2006 at 11:40:05AM -0600, Jessica M Salmon wrote:
> I am brand new to creating my own data types in postgres. I first created
a
> type called "indices", containing two integers. Now, I want to create
> another type, called "progress", which should contain one timestamp and
an
> array of "indices". However, I cannot figure out how to get postgres to
> recognize the array of my home-brewed composite data type as a valid data
> type. Can I just insert a new element into the pg_type table, for a type
> called "_indices"?

http://www.postgresql.org/docs/8.1/interactive/arrays.html

"Arrays of any built-in or user-defined base type can be created.
(Arrays of composite types or domains are not yet supported,
however.)"

What are you trying to model?  Have you considered other ways of
representing it?

--
Michael Fuhr