Appending values non-destructively

Поиск
Список
Период
Сортировка
От Andre Dubuc
Тема Appending values non-destructively
Дата
Msg-id 20020508103600.9B840200093@localhost.localdomain
обсуждение исходный текст
Ответы Re: Appending values non-destructively  ("Joshua b. Jore" <josh@greentechnologist.org>)
Список pgsql-novice
Using PostgreSQL 7.2 with PHP 4.1.2,  I would like to use the UPDATE function
to add values to a field in a row that already has a value or values, i.e.:
in a field named 'sponsor', the current value is '2588'. I would like the new
value in 'sponsor' to become '2588, 2961', and later , '2588, 2961, 3166' etc.

From my newbie reading, I haven't discovered whether it is possible to append
values to a field without destroying the current value, and further, whether
comma separators (or any sprators for that fact) are allowed or even possible.

If some kind guru could help out with this simple question, I would greatly
appreciate a small example code showing how to do it.

Tia,
Andre


--
Please pray the Holy Rosary to end the holocaust of abortion.
Remember in your prayers the Holy Souls in Purgatory.

May God bless you abundantly in His love!
For a free Cenacle Scriptural Rosary Booklet: http://www.webhart.net/csrb/

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Henshall, Stuart - WCP"
Дата:
Сообщение: Re: Functions replicating stored procedures
Следующее
От: "Joshua b. Jore"
Дата:
Сообщение: Re: Incorrect Query