Re: Null boolean values show as false in the data

Поиск
Список
Период
Сортировка
От Ben Trewern
Тема Re: Null boolean values show as false in the data
Дата
Msg-id BAY8-F125BOh8s4KWiG00036f81@hotmail.com
обсуждение исходный текст
Список pgadmin-support
Sorry for the noise.

Ben

>From: Andreas Pflug <pgadmin@pse-consulting.de>
>To: Ben Trewern <ben_trewern@hotmail.com>
>CC: pgadmin-support@postgresql.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@postgresql.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/



В списке pgadmin-support по дате отправления:

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: Null boolean values show as false in the data
Следующее
От: "Camelia Botez"
Дата:
Сообщение: compiling pgsql7.4.1 on solaris 9