How to turn a column of ints into one array in postgres

Question

I currently have a table with one column and 400 rows; each row has an integer. How can I create an int array with all of these integers that preserves order?

I am using postgreSQL-9.2.

user330315 · Accepted Answer · 2015-07-27 13:31:19Z

1

select array_agg(int_column order by some_column) as int_array_column
from the_table;

Where some_column is the column that defines the "order" of the integer values. Rows in relational database do not have "an order", so your request "that preserves order" only makes sense if you have a column that defines that sort order that you try to preserve.

answered Jul 27, 2015 at 13:31

user330315

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

Comments

Ram · Accepted Answer · 2015-07-27 16:50:15Z

0

SELECT array_agg(column_name ORDER by sort_column_name) AS ints
FROM table

edited Jul 27, 2015 at 16:50

Ram

3,09110 gold badges43 silver badges57 bronze badges

answered Jul 27, 2015 at 13:31

Walker Farrow

4,0289 gold badges36 silver badges58 bronze badges

1 Comment

user155407 Over a year ago

Code-only answers are discouraged, because they contain no searchable content. They also don't explain why they should "try this", and we make an effort here to be a resource for knowledge. Posting a block of code with no other information isn't sharing knowledge - it's just offering copy/paste code.

Collectives™ on Stack Overflow

How to turn a column of ints into one array in postgres

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related