node-postgres returning multiple array_length() columns?

Question

I have 3 array columns and i am trying to get the count for each of these arrays but node-postgres is only returning one of them which is the last array_length() passed in the SQL statement. I passed the same sql query using the postgres console and it returned all the results.

PostgreSQL and node_postgres versions? Exact query text and exact output text? Sample data? Unless someone here has psychic powers... — Craig Ringer
– Craig Ringer, Commented Feb 5, 2013 at 1:30

Anthon · Accepted Answer · 2013-04-11 08:08:20Z

1

Ok figured it out, the array query needs to be wrapped in brackets

(array_length(friends,1),array_length(clients, 1),array_length(venues, 1))

and this will return for e.g (3,3,7), otherwise only the last query will return (7).

edited Apr 11, 2013 at 8:08

Anthon

78.2k35 gold badges206 silver badges288 bronze badges

answered Feb 5, 2013 at 3:19

RubyGladiator

1,7653 gold badges19 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

node-postgres returning multiple array_length() columns?

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