Merlin Moncure <mmoncure@gmail.com> writes:
> Is there any reason why array functions need the type prefix when
> other type conversion functions don't? Why didn't we name unnest()
> array_unnest()?
UNNEST() is in the standard, IIRC, so you'd have to ask the SQL
committee that. (And no, they're not exactly being consistent either,
see array_agg() for example.)
But anyway, my point here is that these functions are close enough to
the existing string_to_array/array_to_string functions that they should
be presented as variants of those, not arbitrarily assigned unrelated
new names. Whether we'd have chosen different names if we had it to do
over is academic.
regards, tom lane