Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 9C0E6476A5B
	for <pgsql-sql@postgresql.org>; Thu,  2 Jan 2003 01:09:53 -0500 (EST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id 32D0F476443
	for <pgsql-sql@postgresql.org>; Thu,  2 Jan 2003 01:05:06 -0500 (EST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h0264vd0017828;
	Thu, 2 Jan 2003 01:04:58 -0500 (EST)
To: floyds@4peakstech.com
Cc: "Pgsql-Sql" <pgsql-sql@postgresql.org>
Subject: Re: empty arrays 
In-reply-to: <NDBBKEGJICMIMJHJEBCOKENLFOAA.floyds@4peakstech.com> 
References: <NDBBKEGJICMIMJHJEBCOKENLFOAA.floyds@4peakstech.com>
Comments: In-reply-to <floyds@4peakstech.com>
	message dated "Mon, 30 Dec 2002 11:40:44 -0600"
Date: Thu, 02 Jan 2003 01:04:57 -0500
Message-ID: <17827.1041487497@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/12
X-Sequence-Number: 10877

<floyds@4peakstech.com> writes:
> # insert into test_table (test_column) values ( '{ }' );

Try it without the space:

insert into test_table (test_column) values ( '{}' );

			regards, tom lane