How to find the size of an array in postgresql
arrays, postgresql, size, sql
Solution
As vyegorov mentioned, `array_length` will do the trick. Or if you know that the array is 1-dimensional (which is likely) and are running PostgreSQL 9.4 or higher, you can use `cardinality`:
SELECT cardinality(id) FROM example;
Problem
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 ```