Possible to UPDATE array[] columns?

From: "Blake Starkenburg" <blake(at)oldride(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Possible to UPDATE array[] columns?
Date: 2009-10-30 17:47:26
Message-ID: IFEKLFOMIHMILPPMMCFECEFFKHAA.blake@oldride.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Using SQL is it possible to UPDATE (append) onto an array[] column. For
example say I have a column named "scores int[]".

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}. I thought maybe simply leaving the array key empty
would auto-append "UPDATE table set scores[] = 12 WHERE id = 2", not so....

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2009-10-30 18:18:53 Re: Possible to UPDATE array[] columns?
Previous Message Thomas Kellerer 2009-10-30 17:47:08 Re: Correlated Subquery and calculated column non-functional