updating elements of an array which is part of a composite type?
От
Celia McInnis
Тема
updating elements of an array which is part of a composite type?
Дата
Msg-id
20050601143613.M49013@drmath.ca
Список
Дерево обсуждения
updating elements of an array which is part of a composite type? "Celia McInnis" <celia@drmath.ca>
Re: updating elements of an array which is part of a composite type? Michael Fuhr <mike@fuhr.org>
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 по дате отправления
От: David Norris
Дата: