How to get an array size (and the biggest) with an SQL statement?

Question

I am using postgres and some of my table's field are arrays. I am looking for the biggest array is there any way to find this info with a SQL statement ?

CREATE TABLE chapter
(....
chapter_path integer[],
.....)

My chapter path are like that {x,y,z} {x,y} {x}

How with a SQL statement can I get 3 corresponding to {x,y,z} integer array size ?

Frank Heikens · Accepted Answer · 2010-12-08 13:04:08Z

4

Use array_upper().

answered Dec 8, 2010 at 13:04

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

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

3 Comments

Spredzy Over a year ago

Unfortunately, my arrays are arrays of uuid and not simple integer I put it up for the demo. Thanks anyway for the answer.

Spredzy Over a year ago

The array_lenght function of the page you gave me made the trick. Thank You !

indago Over a year ago

@Frank , is there a difference between array_upper() and array_length() ?? Is there an advantage of using one over the other? or are there situations where you must use one and not the other?

Collectives™ on Stack Overflow

How to get an array size (and the biggest) with an SQL statement?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related