Re: list manipulation at column level - Mailing list pgsql-general

From Chris Travers
Subject Re: list manipulation at column level
Date
Msg-id 4324B780.9040107@travelamericas.com
Whole thread Raw
In response to list manipulation at column level  (Matthew Peter <survivedsushi@yahoo.com>)
Responses Re: list manipulation at column level
List pgsql-general
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


pgsql-general by date:

Previous
From: Matthew Peter
Date:
Subject: list manipulation at column level
Next
From: Michael Fuhr
Date:
Subject: Re: list manipulation at column level