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
using: psql (PostgreSQL) 7.2.1
why does an empty array return an array of length 1 rather than array of
length 0? one would think that the results below would have returned { }
instead of {0}.
simple test using psql:
# create table test_table ( test_column integer[] );
CREATE
# insert into test
