Is there a way to select a list of column values directly into an array?
create table foo (col1 text);
insert into foo (col1) values ('aaa'),('bbb'),('ccc'),('ddd'),('eee');
I'd like to load up an array with {aaa,bbb,ccc,ddd,eee}, prefferably with a single select statement.
Thanks in advance for any help!