Appending values non-destructively
От | Andre Dubuc |
---|---|
Тема | Appending values non-destructively |
Дата | |
Msg-id | 20020508103600.9B840200093@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: Appending values non-destructively
|
Список | 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 по дате отправления: