Re: Possible to insert quoted null value into integer field? - Mailing list pgsql-general

Jan Wieck wrote:

> On 8/26/2004 4:27 AM, gnari wrote:
>
>> "Pablo S" <pablo_tweek@yahoo.com> wrote:
>>
>>
>>> Hi all, I have search high and low on this -
>>> Take for instance the statement :
>>> insert into foo (text1, text2, int1) values ('Foo', 'Bar', '');
>>>
>>> On Pg 7.2.x, the db would happily insert the null val into the int
>>> field.  HOWSOMEVER, 7.4.x will explode and error back with:
>
>
> You aren't inserting an SQL NULL value. You try to insert an empty
> string, which is not a valid integer representation.
>
>
> Jan

And IIRC for oracle an empty string is a NULL value  :-(


Regards
Gaetano Mendola