updating elements of an array which is part of a composite type? - Mailing list pgsql-novice

From Celia McInnis
Subject updating elements of an array which is part of a composite type?
Date
Msg-id 20050601143613.M49013@drmath.ca
Whole thread Raw
Responses Re: updating elements of an array which is part of a composite type?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
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 ...

indicating that the first bracket is not acceptable.

I have no trouble selecting via:

   select (mytype).myarray[1] from mytable;

Thanks for any help.
Celia McInnis


pgsql-novice by date:

Previous
From: David Norris
Date:
Subject: Novice question: PostgreSQL 7.2.4 running on RedHat linux
Next
From: Andrew Hammond
Date:
Subject: Re: Functions