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 36C939DCBEF for ; Mon, 9 Jan 2006 04:20:39 -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 08865-08 for ; Mon, 9 Jan 2006 04:20:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from hp.sduept.com (unknown [60.208.83.220]) by postgresql.org (Postfix) with ESMTP id 399899DCBE8 for ; Mon, 9 Jan 2006 04:20:32 -0400 (AST) Received: from [192.168.1.36] (soft36.sduept.com [192.168.1.36]) by hp.sduept.com (8.13.1/8.13.1) with ESMTP id k098IBAs026536; Mon, 9 Jan 2006 16:18:30 +0800 Message-ID: <43C21C43.8020006@sduept.com> Date: Mon, 09 Jan 2006 16:18:11 +0800 From: JiangWei User-Agent: Mozilla Thunderbird 1.0.7-1.1.fc4 (X11/20050929) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Volkan YAZICI CC: pgsql-interfaces@postgresql.org Subject: Re: HOWTO pass "default value" to PQexecParams? References: <43BDC4EF.7090408@sduept.com> <20060107094455.GA634@alamut> In-Reply-To: <20060107094455.GA634@alamut> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.112 required=5 tests=[AWL=0.112] X-Spam-Score: 0.112 X-Spam-Level: X-Archive-Number: 200601/12 X-Sequence-Number: 5928 Volkan YAZICI 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.