Re: [SQL] inet problem - Mailing list pgsql-sql

From Olivier BLONDEAU
Subject Re: [SQL] inet problem
Date
Msg-id 199904141252.OAA04011@zeitoun.entreprises.cegetel.fr
Whole thread Raw
In response to Re: [SQL] inet problem  ("D'Arcy" "J.M." Cain <darcy@druid.net>)
List 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.


pgsql-sql by date:

Previous
From: "D'Arcy" "J.M." Cain
Date:
Subject: Re: [SQL] inet problem
Next
From: José Soares
Date:
Subject: Re: [SQL] external environment variable