How to Append Integer to Integer Array in an Existing Row in PostgreSQL

Question

I have created a Table as follows

CREATE TABLE parentChild
(
  id serial NOT NULL,
  parentID integer,
  childIds integer[],
  CONSTRAINT PARENTCHILD_pkey PRIMARY KEY (id)
)

I have also Inserted several elements in this table

Initial Table View

id | ParentID | ChildIDs
------------------------
1  | 0        | 
2  | 0        |

When I insert Child of "1" where child ID will be 3 and its parent ID will be 1, I wish to append 3 to the Child IDs integer array at id=1 as shown below.

id | ParentID | ChildIDs
------------------------
1  | 0        | 3,4
2  | 0        |
3  | 1        |

Could you please let me know how to achieve this?

agim · Accepted Answer · 2015-05-23 08:29:45Z

1

Here you can find array operators: http://www.postgresql.org/docs/9.1/static/functions-array.html

You can try this query:

Update parentChild
Set childid = childid || 3
Where id = 1

answered May 23, 2015 at 8:29

agim

1,84113 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

How to Append Integer to Integer Array in an Existing Row in PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related