Re: Appending values non-destructively

Well sure you can do that but there isn't anything special about a
delimiter. In general the value is atomic and there isn't anything smaller
than it. You could probably use a CASE expression to append new data to
the value or start the value. It almost sounds like you might want to
check out the array type and work with *that* instead since that at least
is an atomic collection of values. This isn't a case of being destructive,
you just have to include the previous value in the new value you write.
That's just standard stuff.

Joshua b. Jore
http://www.greentechnologist.org

On Wed, 8 May 2002, Andre Dubuc wrote:

> 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/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>