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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
