"Florian G. Pflug" <fgp(at)phlo(dot)org> writes:
> Since postgres disallows empty array literals (array[] gives an syntax
> error), I guess creating empty array by removing the last element is
> quite hackish too... Will empty arrays be eventually supported, or will
> they be forbidden entirely (e.g, making "array[1] - 1" return null)?
They're supported now, but you have to write something like
'{}'::int8[]
since "array[]" doesn't provide any context for guessing the intended
array element type.
regards, tom lane