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
Дата:
От: Andrew Hammond
Дата:
Сообщение: Re: Functions
FAQ