Received: from mail.enterprise.net (mail.enterprise.net [194.72.192.18]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA20953 for ; Sat, 16 Oct 1999 14:48:34 -0400 (EDT) (envelope-from olly@lfix.co.uk) Received: from linda.lfix.co.uk (root@max03-001.enterprise.net [194.72.196.1]) by mail.enterprise.net (8.8.5/8.8.5) with ESMTP id TAA02294; Sat, 16 Oct 1999 19:48:31 +0100 (GMT/BST) Received: from lfix.co.uk (olly@localhost [127.0.0.1]) by linda.lfix.co.uk (8.9.3/8.9.3/Debian 8.9.3-6) with ESMTP id TAA23996; Sat, 16 Oct 1999 19:48:26 +0100 Message-Id: <199910161848.TAA23996@linda.lfix.co.uk> X-Authentication-Warning: linda.lfix.co.uk: Host olly@localhost [127.0.0.1] claimed to be lfix.co.uk X-Mailer: exmh version 2.0.2 2/24/98 (debian) To: Stephan Bauer cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] NOT NULL and postgres 6.5.2 In-Reply-To: Message from Stephan Bauer of "Sat, 16 Oct 1999 20:10:02 +0200." <3808BF7A.A83120D5@gmx.de> References: <3808BF7A.A83120D5@gmx.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Sat, 16 Oct 1999 19:48:26 +0100 From: "Oliver Elphick" Stephan Bauer wrote: >Hello all, > >I have an table like this: > >CREATE TABLE anzeigen ( >... > > name varchar(30) NOT NULL, >... >); > >The following statement _will_ be inserted: > >INSERT INTO anzeigen ( ... name ...) >VALUES ( ..., '', ...); > >What is my problem? An empty string is not the same as null. It is a real value whereas null is an unknown/undefined/irrelevant value. -- Vote against SPAM: http://www.politik-digital.de/spam/ ======================================== Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID 32B8FAA1 ======================================== "But be ye doers of the word, and not hearers only, deceiving your own selves." James 1:22