X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5AB21D1B1C8 for ; Fri, 16 Jul 2004 12:51:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01477-10 for ; Fri, 16 Jul 2004 15:50:56 +0000 (GMT) Received: from ns1.syntegra.com (ns1.syntegra.com [150.143.16.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3D688D1B1EC for ; Fri, 16 Jul 2004 12:50:53 -0300 (ADT) Received: from [129.179.161.11] by ns1.syntegra.com with ESMTP for pgsql-interfaces@postgresql.org; Fri, 16 Jul 2004 15:50:45 Z Received: from jarjar.arh.us.syntegra.com (jarjar.arh.us.syntegra.com [129.179.16.105]) by ah-intrastore-01.us.syntegra.com with ESMTP for pgsql-interfaces@postgresql.org; Fri, 16 Jul 2004 10:50:45 -0500 Received: from [129.179.16.111] ([129.179.16.111] [129.179.16.111]) by jarjar.arh.cdc.com with ESMTP for pgsql-interfaces@postgresql.org; Fri, 16 Jul 2004 10:48:12 -0500 X-Mailer: Claris Emailer 2.0v3 , January 8, 1998 Date: Fri, 16 Jul 2004 10:50:43 -0500 Subject: NULLs in ecpg From: To: Message-Id: In-Reply-To: <6.0.3.0.2.20040701171811.02921908@nis-pop.lanl.gov> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200407/26 X-Sequence-Number: 5032 I couldn't find this in the archives... In an ecpg program, given the statement (taken from the manual): EXEC SQL INSERT INTO sometable VALUES (:v1, =B9foo=B9, :v2); Is there a way to create the record where ':v1' is NULL - as with indicators in a FETCH? Or, do I have to generate different SQL statements in the C program? Wes