Re: [DOCS] Postgresql 8.3X supports Arrays of Composite Types?

2009-04-19 Thread Robson Fidalgo
> > Hello, > I am using postgresql 8.3X and I created a table (see example below) that > has an attribute that is an Array of a Composite Type (ROW). However, I do > not know how can I insert a record in this table. > > Well, I've searched the mailing lists and have found little said about the > OR

Re: [DOCS] [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?

2009-04-19 Thread Tom Lane
Robson Fidalgo writes: > I am using postgresql 8.3X and I created a table (see example below) that > has an attribute that is an Array of a Composite Type (ROW). However, I do > not know how can I insert a record in this table. You need some explicit casts so that the array[] construct is seen to

Re: [DOCS] [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?

2009-04-19 Thread David Fetter
On Sun, Apr 19, 2009 at 06:03:26PM -0300, Robson Fidalgo wrote: > Hello, > I am using postgresql 8.3X and I created a table (see example below) > that has an attribute that is an Array of a Composite Type (ROW). > However, I do not know how can I insert a record in this table. You want a normalize