Re: Should we consider empty fields as NULL values when dealing with string columns ?

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Should we consider empty fields as NULL values when dealing with string columns ?
Дата
Msg-id 03AF4E498C591348A42FC93DEA9661B872022A@mail.vale-housing.co.uk
обсуждение исходный текст
Ответ на Should we consider empty fields as NULL values when dealing with string columns ?  ("Nagib Abi Fadel" <nagib.abi-fadel@usj.edu.lb>)
Список pgsql-hackers
 


From: Nagib Abi Fadel [mailto:nagib.abi-fadel@usj.edu.lb]
Sent: 11 December 2003 14:37
To: generalpost; developPost
Subject: [HACKERS] Should we consider empty fields as NULL values when dealing with string columns ?

HI,
let's say we have the following table :
 
# CREATE TABLE tempo (col1 varchar(3) not null);
CREATE TABLE
# insert INTO tempo VALUES ('');
INSERT 11420541 1
 
the insert command works.  
 
As it should. NULL != ''. In other words, NULL is no value at all, whilst '' is an empty string which is a value, albeit one of zero length.
 
Regards, Dave.

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

Предыдущее
От: "Nagib Abi Fadel"
Дата:
Сообщение: Should we consider empty fields as NULL values when dealing with string columns ?
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: [GENERAL] Should we consider empty fields as NULL values when