null and integer field

From: "Hamid Khoshnevis" <hamid(at)emarq(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: null and integer field
Date: 2000-01-20 00:57:17
Message-ID: 000601bf62e1$4c1d1040$810a0a0a@emarq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-01-20 02:20:09 Re: [SQL] null and integer field
Previous Message Daniel Spratlen 2000-01-19 19:16:30 Foreign Keys, Triggers and such