Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Possible to UPDATE array[] columns?
- From: Sam Mason <sam(at)samason(dot)me(dot)uk>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Re: Possible to UPDATE array[] columns?
- Date: Fri, 30 Oct 2009 18:25:23 +0000
- Message-id: <20091030182523.GD5407@samason.me.uk> <text/plain>
On Fri, Oct 30, 2009 at 06:23:28PM +0000, Sam Mason wrote:
> On Fri, Oct 30, 2009 at 10:47:26AM -0700, Blake Starkenburg wrote:
> > ID | scores
> > 2 | {54,14,21,8}
> > 3 | {12,0,7}
> >
> > Now I want to append the score of 12 on row:ID 2 so the new scores would
> > read {54,14,21,8,12}.
>
> You need to use the normal array concatenation operator, ||, for
> example:
>
> UPDATE table SET scores = scores || (
> SELECT scores FROM table WHERE id = 12)
> WHERE id = 2;
Doh, sorry, I was thinking you were asking for something more
complicated. I don't seem to be doing very well here at all today!
--
Sam http://samason.me.uk/
- References:
- Possible to UPDATE array[] columns?
- From: Blake Starkenburg
- Re: Possible to UPDATE array[] columns?
- From: Sam Mason
- Possible to UPDATE array[] columns?
- Prev by Date: Re: Possible to UPDATE array[] columns?
- Next by Date: Re: CREATE TABLE LIKE and SERIAL
- Previous by thread: Re: Possible to UPDATE array[] columns?
- Next by thread: Re: Possible to UPDATE array[] columns?
- Indexes: