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

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Nagib Abi Fadel" <nagib(dot)abi-fadel(at)usj(dot)edu(dot)lb>, "generalpost" <pgsql-general(at)postgresql(dot)org>, "developPost" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Should we consider empty fields as NULL values when dealing with string columns ?
Date: 2003-12-11 15:34:09
Message-ID: 200312111534.09392.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera Munoz 2003-12-11 15:35:58 Re: [GENERAL] Transaction Question
Previous Message Jan Wieck 2003-12-11 15:22:59 Re: add column sillyness

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera Munoz 2003-12-11 15:35:58 Re: [GENERAL] Transaction Question
Previous Message Tom Lane 2003-12-11 15:31:08 Re: 7.4 build problem on Linux Vserver