Issuing on PostgresSQL 9.2 the following:
CREATE TABLE test (j JSON, ja JSON[]);
INSERT INTO test (j) VALUES('{"name":"Alex", "age":20}' ); -- Works FINE
INSERT INTO test (ja) VALUES( ARRAY['{"name":"Alex", "age":20}', '{"name":"Peter", "age":24}'] ); -- Returns ERROR
The first insert works fine. The second insert returns error: column "ja" is of type json[] but expression is of type text[]
I can cast type to prevent the error:
INSERT INTO test(ja) VALUES( CAST (ARRAY['{"name":"Alex", "age":20}', '{"name":"Peter", "age":24}'] as JSON[]) ); -- Works FINE
My question is if there is a way to avoid casting?
