X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E5BEDD1E12E for ; Wed, 18 Feb 2004 21:29:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 01105-01 for ; Wed, 18 Feb 2004 17:29:35 -0400 (AST) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 86D12D1E12B for ; Wed, 18 Feb 2004 17:29:33 -0400 (AST) Received: from [134.22.69.114] (dyn-69-114.tor.dsl.tht.net [134.22.69.114]) by tht.net (Postfix) with ESMTP id 6EC0F76A59; Wed, 18 Feb 2004 16:29:33 -0500 (EST) Subject: Re: Inserting NULL into Integer column From: Rod Taylor To: Scott Marlowe Cc: Jeremy Smith , pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: text/plain Message-Id: <1077139795.18564.420.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Wed, 18 Feb 2004 16:29:56 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/264 X-Sequence-Number: 16954 > Note that the ' marks aren't part of the string, they are the delimiter of > the string, and I always run every server with magic_quotes_gpc on. > > anything else? :-) Good point. I looked at the single quotes of the second line and somehow the DEFAULT got quoted as well ;)