How is that one pgsql build (both are 9.5.2) has different casting behavior for empty arrays:
ericmj=# select ARRAY[]::text[];
array
-------
{}
(1 row)
ericmj=# select (ARRAY[])::text[];
array
-------
{}
(1 row)
--VS--
pedcard=# select ARRAY[]::text[];
array
-------
{}
(1 row)
pedcard=# select (ARRAY[])::text[];
ERROR: cannot determine type of empty array
LINE 1: select (ARRAY[])::text[];
^
HINT: Explicitly cast to the desired type, for example ARRAY[]::integer[].
--
Scott Ribe
scott_ribe@xxxxxxxxxxxxxxxx
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
