current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

How can I put an sql query result in a string array with Postgres? I have some attributes in the column 'zone' of the table 'mytable' and I must put them all in a String[] areas; This is my first request, sorry if I made some format mistake.

share|improve this question
2  
You forgot to provide the data type of the column and your version of Postgres. String[] is not a valid Postgres type. I suppose you mean text[]? And do you want to aggregate all attributes from all rows into one array or just attributes from one row? –  Erwin Brandstetter May 7 at 0:00
    
yes, i use postgres 9.4 and the String[] areas is the array where i will put the text attributes. I want to aggregate all attributes of a column –  Filippo Vimini May 8 at 15:39

1 Answer 1

up vote 1 down vote

You can use an array constructor:

select array(
select zone
from mytable) 
as areas;
share|improve this answer
1  
I feel array_agg() is a bit more convenient, no need to use a subquery, for example. –  dezso May 7 at 10:25
    
@dezso: The array constructor (which is not an "operator"!) is typically faster to build a single array. So this is actually the best technique. –  Erwin Brandstetter May 11 at 3:31
    
I've just made a small test where I see the two producing the exact same query plan, therefore the same execution time. –  dezso May 11 at 13:03

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.