Re: updating elements of an array which is part of a composite type?

On Wed, Jun 01, 2005 at 09:54:38AM -0500, Celia McInnis wrote:
>
> How do I update the elements of an array when the array is part of a
> composite type?
>
> If I type:
>
> update mytable set (mytype).myarray[1]='whatever' where ...;
>
> I get :
>
> ERROR: syntax error at or near "(" at character ...

Remove the parentheses:

UPDATE mytable SET mytype.myarray[1] = 'whatever' WHERE ...;

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/