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@elevated-dev.com
http://www.elevated-dev.com/https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
