pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedinet problem
3+ messages / 2 participants
[nested] [flat]
* inet problem
@ 1999-04-14 08:45 Olivier BLONDEAU <olivier@blondeau.net>
0 siblings, 1 reply; 3+ messages in thread
From: Olivier BLONDEAU @ 1999-04-14 08:45 UTC (permalink / raw)
To: pgsql-sql
Hi,
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.
So, if someone knows a way to do this, I'm listenig to him ;*)
Thaks a lot for your help.
Olivier.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] inet problem
@ 1999-04-14 12:15 D'Arcy J.M. Cain <darcy@druid.net>
parent: Olivier BLONDEAU <olivier@blondeau.net>
0 siblings, 1 reply; 3+ messages in thread
From: "D'Arcy" "J.M." Cain @ 1999-04-14 12:15 UTC (permalink / raw)
To: olivier@blondeau.net; +Cc: 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@{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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] inet problem
@ 1999-04-14 12:52 Olivier BLONDEAU <olivier@blondeau.net>
parent: D'Arcy J.M. Cain <darcy@druid.net>
0 siblings, 0 replies; 3+ messages in thread
From: Olivier BLONDEAU @ 1999-04-14 12:52 UTC (permalink / raw)
To: pgsql-sql
> Can you show how it fails? It works for me.
>
> darcy=> update x set i = null;
> UPDATE 1
> darcy=> select * from x;
> i
> -
Ok... It works for me too...
The problem comes from pgaccess who try to make the update like this:
update x set i = 'null';
In this case, ProstgeSQL says he cannot parse "null".
As i thought pgaccess was using the right way, I did the same error in my
php function...
But it works now !
Thanks a lot...
Olivier.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-04-14 12:52 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-04-14 08:45 inet problem Olivier BLONDEAU <olivier@blondeau.net>
1999-04-14 12:15 ` D'Arcy J.M. Cain <darcy@druid.net>
1999-04-14 12:52 ` Olivier BLONDEAU <olivier@blondeau.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox