Модификация отдельного элемента

Листинг 7.27. Модификация отдельного элемента

booktown=# SELECT books[l] FROM favorite_books;

books

The Hitchhiker's Guide to the Galaxy The Hobbit

(2 rows)

booktown=# UPDATE favorite_books

booktown-# SET books[l] = 'There and Back Again: A HobbitVs Holiday'

booktown-# WHERE books[l] = 'The Hobbit';

UPDATE 1

booktown=# SELECT books[l] FROM favorite_books;

books

The Hitchhiker's Guide to the Galaxy

There and Back Again: A Hobbit's Holiday

(2 rows)