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:59:05 |
Message-ID: | BAY8-F125BOh8s4KWiG00036f81@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Sorry for the noise.
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: Thu, 14 Oct 2004 13:52:17 +0000
>
>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now!
http://toolbar.msn.co.uk/
From | Date | Subject | |
---|---|---|---|
Next Message | Camelia Botez | 2004-10-14 14:33:58 | compiling pgsql7.4.1 on solaris 9 |
Previous Message | Andreas Pflug | 2004-10-14 13:52:17 | Re: Null boolean values show as false in the data |