By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
create table your_function_output(result int[]);
insert into your_function_output values
( null ),--plain null
(ARRAY[ null ]::int[]),--an array with a null in it
(ARRAY[ ]::int[]),--an empty array
(ARRAY[ 1 ]::int[]),--single-element array
(ARRAY[1,2,3 ]::int[]),--multiple-element array
(ARRAY[1,-5,2]::int[]),--different order
(ARRAY[1,null]::int[]) --array with a null as one of the elements
returning *;
CREATE TABLE
| result |
|---|
| null |
| {NULL} |
| {} |
| {1} |
| {1,2,3} |
| {1,-5,2} |
| {1,NULL} |
INSERT 0 7