null and integer field - Mailing list pgsql-sql

From Hamid Khoshnevis
Subject null and integer field
Date
Msg-id 000601bf62e1$4c1d1040$810a0a0a@emarq
Whole thread Raw
Responses Re: [SQL] null and integer field  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
The content of an integer field when unassigned appears to be different from
pushing a null into that field.   Can someone please explain the difference
and show me how to push an 'unassigned' into that integer field.

I am using:
update table foo set integer_field=null where blah blah;

Thanks,

hamid



pgsql-sql by date:

Previous
From: Marc Tardif
Date:
Subject: Re: [SQL] Foreign Keys, Triggers and such
Next
From: Tom Lane
Date:
Subject: Re: [SQL] null and integer field