Re: list manipulation at column level

From: Chris Travers <chris(at)travelamericas(dot)com>
To: Matthew Peter <survivedsushi(at)yahoo(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: list manipulation at column level
Date: 2005-09-11 23:02:24
Message-ID: 4324B780.9040107@travelamericas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-09-11 23:25:01 Re: list manipulation at column level
Previous Message Matthew Peter 2005-09-11 22:33:28 list manipulation at column level