On Apr 21, 2016, at 8:25 PM, Alvaro Aguayo Garcia-Rada
<[email protected]> wrote:
>
> Looks like one has the appropiate cast operator, while the other hasn't. Have
> you tried doing the same, on both server, on an empty database created from
> template0?
Excellent suggestion:
pedcard=# create database test;
CREATE DATABASE
pedcard=# \c test
SSL connection (protocol: TLSv1, cipher: DHE-RSA-AES256-SHA, bits: 256,
compression: off)
You are now connected to database "test" as user "admin".
test=# 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
[email protected]
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
