Re: Null boolean values show as false in the data

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Ben Trewern <ben_trewern(at)hotmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Null boolean values show as false in the data
Date: 2004-10-14 13:52:17
Message-ID: 416E8491.2020800@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Ben Trewern wrote:
> While your at it null values need to be treated correctly for other
> field types.
>
> I don't think "" = <null> in Postgres. If so then it would be nice to
> be able to set text/varchar to null somehow.

NULL *is* handled for text. An empty field is handled as NULL, an empty
string must be entered ''. This is documented.

Regards,
Andreas

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Ben Trewern 2004-10-14 13:59:05 Re: Null boolean values show as false in the data
Previous Message Ben Trewern 2004-10-14 13:45:48 Re: Null boolean values show as false in the data