Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Robson Fidalgo <rdnf(at)cin(dot)ufpe(dot)br>
- Cc: pgsql-docs(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
- Subject: Re: [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?
- Date: Sun, 19 Apr 2009 19:25:32 -0400
- Message-id: <12292.1240183532@sss.pgh.pa.us> <text/plain>
Robson Fidalgo <rdnf(at)cin(dot)ufpe(dot)br> 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
have the right type, eg
insert into person values ('Joe', array[row('1','1111')::phone, row('2','2222')::phone]);
regards, tom lane
- Prev by Date: Re: Postgresql 8.3X supports Arrays of Composite Types?
- Next by Date: Re: [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?
- Previous by thread: Re: Postgresql 8.3X supports Arrays of Composite Types?
- Next by thread: Re: [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?
- Indexes: