Skip site navigation (1) Skip section navigation (2)

Re: Null boolean values show as false in the data

From: "Ben Trewern" <ben_trewern(at)hotmail(dot)com>
To: pgadmin(at)pse-consulting(dot)de
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Null boolean values show as false in the data
Date: 2004-10-14 13:45:48
Message-ID: BAY8-F121WerOc0Ne0P00014024@hotmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
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.

Regards,

Ben

>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: [pgadmin-support] Null boolean values show as false in the 
>data
>Date: Tue, 12 Oct 2004 09:31:54 +0000
>
>Ben Trewern wrote:
>>All,
>>
>>PgAdmin III 1.2 beta 2
>>Postgres 8.0 beta 2
>>
>>I've just noticed that null values in boolean fields show up as false in 
>>the data grid.
>
>You're right, and unfortunately there's no quick fix for this. We're using 
>a wxGridCellBoolEditor internally, which only knows two states. We'll have 
>to redesign that completely. I'll have to think about that a little; in the 
>meantime, I've put it on BUGS.txt.
>
>Regards,
>Andreas
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend

_________________________________________________________________
Use MSN Messenger to send music and pics to your friends 
http://www.msn.co.uk/messenger


Responses

pgadmin-support by date

Next:From: Andreas PflugDate: 2004-10-14 13:52:17
Subject: Re: Null boolean values show as false in the data
Previous:From: Andreas PflugDate: 2004-10-14 11:30:24
Subject: Re: Status bar

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group