Re: Should we consider empty fields as NULL values when dealing with string columns ? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Should we consider empty fields as NULL values when dealing with string columns ?
Date
Msg-id 200312111534.09392.dev@archonet.com
Whole thread Raw
In response to Should we consider empty fields as NULL values when dealing with string columns ?  ("Nagib Abi Fadel" <nagib.abi-fadel@usj.edu.lb>)
List pgsql-general
On Thursday 11 December 2003 14:36, Nagib Abi Fadel wrote:
> 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

I don't have much to add to Doug's reply, but you may want to look at:
http://techdocs.postgresql.org/guides/BriefGuideToNulls

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Storing Snapshot Data
Next
From: Tino Wildenhain
Date:
Subject: Re: Should we consider empty fields as NULL values when