Postgres Pro
Downloads
Home   >   mailing lists

Re: Null boolean values show as false in the data - Mailing list pgadmin-support

From Andreas Pflug
Subject Re: Null boolean values show as false in the data
Date
Msg-id 416E8491.2020800@pse-consulting.de
Whole thread Raw
In response to Re: Null boolean values show as false in the data  ("Ben Trewern" <ben_trewern@hotmail.com>)
List pgadmin-support
Tree view 
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

pgadmin-support by date:

Previous
From: "Ben Trewern"
Date:
Subject: Re: Null boolean values show as false in the data
Next
From: "Ben Trewern"
Date:
Subject: Re: Null boolean values show as false in the data