Hackers,
This surprised me:
david=# select array_length('{}'::text[], 1); array_length -------------- [null]
I had expecte dit to retur 0. I might expect NULL for a NULL param, but not one that's defined but has no elements.
Best,
David