Caution!
In 7.2.x your statement is interpreted by the parser to be a single element
with an empty string which is converted to a zero. If you do this instead:
create table test_table ( test_column integer[], another_column integer );
CREATE
steve=# insert into test_table (another_column) values
<[EMAIL PROTECTED]> writes:
> # insert into test_table (test_column) values ( '{ }' );
Try it without the space:
insert into test_table (test_column) values ( '{}' );
regards, tom lane
---(end of broadcast)---
TIP 2: you ca
