Malcolm Tredinnick <malcolm(at)commsecure(dot)com(dot)au> writes:
> So given that one cannot just insert 0 into a bigint field (even an
> array of bigints), since postgres complains it is not of the correct
> type, how is one supposed to fille a field of bigint[] with {0, 0}?
I must be missing something ... what is wrong with
regression=# create table foo (bar bigint[]);
CREATE TABLE
regression=# insert into foo values ('{0, 0}');
INSERT 1101788 1
regression=# select * from foo;
bar
-------
{0,0}
(1 row)
regards, tom lane