Received: from druid.net (root@druid.net [198.96.119.226]) by hub.org (8.9.2/8.9.1) with ESMTP id IAA88266 for ; Wed, 14 Apr 1999 08:15:47 -0400 (EDT) (envelope-from darcy@druid.net) Received: from localhost (1365 bytes) by druid.net via sendmail with P:stdio/R:bind_hosts/T:inet_zone_bind_smtp (sender: ) (ident using unix) id for ; Wed, 14 Apr 1999 08:15:23 -0400 (EDT) (Smail-3.2.0.104 1998-Nov-20 #4 built 1999-Apr-13) Message-Id: Subject: Re: [SQL] inet problem In-Reply-To: <199904140845.KAA02262@zeitoun.entreprises.cegetel.fr> from Olivier BLONDEAU at "Apr 14, 1999 10:45:01 am" To: olivier@blondeau.net (Olivier BLONDEAU) Date: Wed, 14 Apr 1999 08:15:23 -0400 (EDT) From: "D'Arcy" "J.M." Cain Cc: pgsql-sql@postgreSQL.org Reply-To: pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL50 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Thus spake Olivier BLONDEAU > I'm using the 6.4.2 version of PostgreSQL and I can't find the way to clear > a inet field. > > I have a table with 5 inet fields, and I'm unable, when one of them is set > to a value, to make it null. Can you show how it fails? It works for me. darcy=> create table x (i inet); CREATE darcy=> insert into x values ('192.168.1.2'); INSERT 63049 1 darcy=> select * from x; i ----------- 192.168.1.2 (1 row) darcy=> update x set i = null; UPDATE 1 darcy=> select * from x; i - (1 row) -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.