Re: TEXT and NULL...

Whether storing NULL values in a relational database is a good idea is at
best highly contentious. Chris Date, one of the pioneers of relational
database theory, rejects them outright as a violation of the relational
model. You might want to check out one of his books and then make up your
own mind.

One thing that an empty string has going for it is that "" = "", and
nothing else does, whereas NULL is not equal to null (and is not even a
value).

Food for thought...

Dan Weston


On Mon, 17 Jun 2002, Herbert Liechti wrote:

> On Mon, 17 Jun 2002, Egon Sommer wrote:
>  > Hallo all,
>  >
>  > Does it make any difference to save "no data" in a column with type TEXT or BYTEA as "" (empty string) or null?
>  > Is one of it faster or more wast of memory?
>
> Always store NULL instead of empty strings. This will it make much
> more easier in programming where you don't have to bother about
> two conditions (NULL and empty string). An empty string on the
> other hand may be a value in an application context where NULL is per
> definition always the same. Storing NULL values is a good feature
> of DBMS so use it ;-) Querying NULL values is part of the SQL-Syntax.
>
> Best regards
> Herbie
>
>
>