Hi, Is there a particular reason why the array constructor requires at least one argument? It's a bit irriating to have to special case zero length arrays.
# select array[];
ERROR: syntax error at or near "]" at character 14
# select array[1];
array
-------
{1}
(1 row)
# select '{}'::int4[];
int4
------
{}
(1 row)
Have a nice day,
--
Martijn van Oosterhout <[email protected]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
