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 A253F9DC834 for ; Mon, 9 Jan 2006 20:51:00 -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 48410-08 for ; Mon, 9 Jan 2006 20:51:03 -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 76EF09DC892 for ; Mon, 9 Jan 2006 20:50:54 -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 k0A0mh63032138; Tue, 10 Jan 2006 08:48:52 +0800 Message-ID: <43C3046B.90501@sduept.com> Date: Tue, 10 Jan 2006 08:48:43 +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> <43C21C43.8020006@sduept.com> <20060109104145.GA546@alamut> In-Reply-To: <20060109104145.GA546@alamut> Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.106 required=5 tests=[AWL=0.104, HTML_MESSAGE=0.001, MIME_HTML_ONLY=0.001] X-Spam-Score: 0.106 X-Spam-Level: X-Archive-Number: 200601/16 X-Sequence-Number: 5932 Volkan YAZICI wrote:

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?

Yes.

If so, is this supported by PostgreSQL?

No. Just an idea. "EXPRESSION_OID" for 'DEFAULT' , ' foo ( id, 2) ', 'm * n + x' ...