Appending values non-destructively

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/

Responses

Browse pgsql-novice by date

  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