Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 25EBD9FB27F for ; Thu, 23 Nov 2006 14:41:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 51234-04 for ; Thu, 23 Nov 2006 14:41:39 -0400 (AST) X-Greylist: delayed 00:29:43.419156 by SQLgrey-1.7.4 Received: from smtp1.pcisys.net (smtp1.pcisys.net [216.229.32.113]) by postgresql.org (Postfix) with ESMTP id A0AE09FB228 for ; Thu, 23 Nov 2006 14:41:31 -0400 (AST) Received: from [192.168.8.101] (dsl-206-53-17-71.cos.pcisys.net [206.53.17.71]) (authenticated bits=0) by smtp1.pcisys.net (8.13.6/8.13.6) with ESMTP id kANIBi31028999 for ; Thu, 23 Nov 2006 11:11:46 -0700 (MST) User-Agent: Microsoft-Entourage/11.2.5.060620 Date: Thu, 23 Nov 2006 11:11:43 -0700 Subject: Set NULL Using PQexecParams From: Keary Suska To: Postgres-Interfaces Message-ID: Thread-Topic: Set NULL Using PQexecParams Thread-Index: AccPKtRoEsSWCHseEduhvQADk83m0A== Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/12 X-Sequence-Number: 6327 Is it possible to set a NULL value as a parameter value to PQexecParams? I.e., other than hard-coding it into the command string. The idea is mostly for UPDATE statements, so a column could be set to null if it otherwise does not have a valid value. Thanks, Keary Suska Esoteritech, Inc. "Demystifying technology for your home or business"