updating a column with array type using other columns in postgresql

Question

I have a table like this:

+-----+------------+-------+--------+-----------+
| ID  |  val1      | val2  | val3   |  array_3  |
+-----+------------+-------+--------+-----------+
| 100 |  110       | 25    | 53     |{110,25,53}|
| 101 |  56        | 75    | 59     |{56,75,59} |
| 102 |  65        | 93    | 82     |{65,93,82} |
| 103 |  75        | 70    | 80     |{75,70,80} |
+-----+------------+-------+--------+-----------+

imagine I have the values for ID, val1, val2 and val3 columns and I want the resulting array in the array_3 table which is an array type and its size is 1*3. How can I do that?

Craig Ringer · Accepted Answer · 2012-11-20 02:20:39Z

2

Array constructor?

http://sqlfiddle.com/#!12/c297a/

SELECT "ID", ARRAY[val1,val2,val3], array_3
FROM table1;

To put the output in a separate table use CREATE TABLE .. AS.

answered Nov 20, 2012 at 2:20

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

f.ashouri Over a year ago

thank you, already informative. but my array_3 column is empty now and I want to fill it with the values like that I've already out in the table.

Craig Ringer Over a year ago

@f.ashouri Then use the array constructor in an UPDATE. It was hard to tell exactly what you were wanting to do with it.

f.ashouri · Accepted Answer · 2012-11-20 02:33:22Z

2

update mytable set array_3=ARRAY[pix_val1, pix_val2]

answered Nov 20, 2012 at 2:33

f.ashouri

5,75713 gold badges48 silver badges54 bronze badges

Collectives™ on Stack Overflow

updating a column with array type using other columns in postgresql

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related