Re: Appending values non-destructively - Mailing list pgsql-novice

Thanks Joshua,

I think I have more reading to do: I've sort of 'avoided' arrays and triggers, but reading what you're suggesting (and
Stuart'sideas), I think I'll need to bone up on these areas.  

Great fun -- in the last month I've been learning PHP, so I guess it's Postgresql's turn now!

Regards,
Andre


On Wednesday 08 May 2002 10:08 am, you wrote:
> 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)

--
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/