agora inbox for pgsql-hackers@postgresql.org  

help / color / mirror / Atom feed

From: Richard Huxton <dev@archonet.com>
To: Nagib Abi Fadel <nagib.abi-fadel@usj.edu.lb>
To: generalpost <pgsql-general@postgresql.org>
To: developPost <pgsql-hackers@postgresql.org>
Subject: Re: Should we consider empty fields as NULL values when dealing with string columns ?
Date: Thu, 11 Dec 2003 15:34:09 +0000
Message-ID: <200312111534.09392.dev@archonet.com> (raw)
In-Reply-To: <001401c3bff4$49abd7f0$f664a8c0@nagib>
References: <001401c3bff4$49abd7f0$f664a8c0@nagib>

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

view thread (9+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: dev@archonet.com, nagib.abi-fadel@usj.edu.lb, pgsql-general@postgresql.org
  Subject: Re: Should we consider empty fields as NULL values when dealing with string columns ?
  In-Reply-To: <200312111534.09392.dev@archonet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox