From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Chris Travers <chris(at)travelamericas(dot)com> |
Cc: | 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:25:01 |
Message-ID: | 20050911232501.GA52427@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, Sep 11, 2005 at 04:02:24PM -0700, Chris Travers wrote:
> 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'
Or use an array type and perform array operations.
http://www.postgresql.org/docs/8.0/interactive/arrays.html
http://www.postgresql.org/docs/8.0/interactive/functions-array.html
CREATE TABLE foo (a text[]);
INSERT INTO foo VALUES ('{some,values,in,a,list,12,34}');
SELECT array_prepend('foo', a) FROM foo;
array_prepend
-----------------------------------------
[0:7]={foo,some,values,in,a,list,12,34}
(1 row)
SELECT array_append(a, 'foo') FROM foo;
array_append
-----------------------------------
{some,values,in,a,list,12,34,foo}
(1 row)
SELECT array_cat(a[1:2], a[6:7]) FROM foo;
array_cat
---------------------
{some,values,12,34}
(1 row)
--
Michael Fuhr
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Peter | 2005-09-12 02:00:38 | Re: list manipulation at column level |
Previous Message | Chris Travers | 2005-09-11 23:02:24 | Re: list manipulation at column level |