From: | Andre Dubuc <aajdubuc(at)webhart(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Appending values non-destructively |
Date: | 2002-05-08 10:36:00 |
Message-ID: | 20020508103600.9B840200093@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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/
From | Date | Subject | |
---|---|---|---|
Next Message | Henshall, Stuart - WCP | 2002-05-08 10:58:15 | Re: Appending values non-destructively |
Previous Message | Henshall, Stuart - WCP | 2002-05-08 09:12:14 | Re: Functions replicating stored procedures |