Re: list manipulation at column level

Matthew Peter wrote:

>Is it possible to append and delete (unknown location)
>items in a list stored in a column? For instance,
>
>a column with 'some,values,in,a,list,12,34';
>
>Could I [ap|pre]pend and or delete items in this list
>through pgsql?
>
>
>
prepend:
'value' || ',' || column
append
column || ',' ||'value'

Delete would require some regular expressions-- check the manual on these.

Or you could write a Perl function.

However, this strikes me as quite denormalized....

Best Wishes,
Chris Travers
Metatron Technology Consulting