How to find the size of an array in postgresql

191

Is there any way to find a size of an array?

For Example,

CREATE TABLE example (id integer[]) ;

INSERT INTO example VALUES ( '{}');

INSERT INTO example VALUES ( '{5,6,7}');

From this, is there any possibilities to get a result like following,

size
---
0
3

sql arrays postgresql size

Edit Report

1 Answer