"Hamid Khoshnevis" <hamid(at)emarq(dot)com> writes:
> 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.
There is no such concept as 'unassigned' in SQL; whatever you are
observing, it's not that. An integer field should indeed be NULL
if it hasn't got a default and you didn't provide a value when you
inserted the tuple.
Can you provide more details about the problem you're having?
regards, tom lane