From: | "D'Arcy" "J(dot)M(dot)" Cain <darcy(at)druid(dot)net> |
---|---|
To: | olivier(at)blondeau(dot)net (Olivier BLONDEAU) |
Cc: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] inet problem |
Date: | 1999-04-14 12:15:23 |
Message-ID: | m10XOZf-0000bHC@druid.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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 <darcy(at){druid|vex}.net> | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Olivier BLONDEAU | 1999-04-14 12:52:38 | Re: [SQL] inet problem |
Previous Message | Olivier BLONDEAU | 1999-04-14 08:45:01 | inet problem |