composite data type question
Hello all.
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"?
Any hints or advice greatly appreciated.
TIA,
Meghan
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
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@fuhr.org>
To
06/07/2006 07:59 Jessica M Salmon
AM <jmsalmon@fs.fed.us>
cc
pgsql-general@postgresql.org
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