X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 7E3FE9DC825 for ; Mon, 9 Jan 2006 06:44:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38428-04 for ; Mon, 9 Jan 2006 06:44:46 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from fep01.ttnet.net.tr (mail.ttnet.net.tr [212.175.13.129]) by postgresql.org (Postfix) with ESMTP id 5568F9DC80C for ; Mon, 9 Jan 2006 06:44:30 -0400 (AST) Received: from alamut ([85.102.233.174]) by fep01.ttnet.net.tr with ESMTP id <20060109104021.ZEH1401.fep01.ttnet.net.tr@alamut>; Mon, 9 Jan 2006 12:40:21 +0200 Date: Mon, 9 Jan 2006 12:41:45 +0200 From: Volkan YAZICI To: JiangWei Cc: pgsql-interfaces@postgresql.org Subject: Re: HOWTO pass "default value" to PQexecParams? Message-ID: <20060109104145.GA546@alamut> References: <43BDC4EF.7090408@sduept.com> <20060107094455.GA634@alamut> <43C21C43.8020006@sduept.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <43C21C43.8020006@sduept.com> User-Agent: Mutt/1.4.2.1i X-NAI-Spam-Rules: 1 Rules triggered BAYES_00=-2.5 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.972 required=5 tests=[AWL=-0.826, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 1.972 X-Spam-Level: * X-Archive-Number: 200601/13 X-Sequence-Number: 5929 On Jan 09 04:18, JiangWei wrote: > >AFAIK, it's not possible to point the field's default value using a > >special value in the related array member. Because, you cannot declare > >any special value in the array: NULL will be treated as NULL and other > >char values as is. > > We can declare a specialized oid for this. You mean in the parameter types? If so, is this supported by PostgreSQL? Regards.