Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 5ABC89F9250 for ; Thu, 8 Nov 2007 16:06:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 59184-08-2 for ; Thu, 8 Nov 2007 16:05:49 -0400 (AST) Received: from mail.attiksystem.ch (f29.attiksystem.ch [212.147.59.29]) by postgresql.org (Postfix) with ESMTP id 5BA589FCB62 for ; Thu, 8 Nov 2007 16:05:46 -0400 (AST) Received: from poweredge.attiksystem.ch (poweredge.attiksystem.ch [10.0.0.29]) by mail.attiksystem.ch (8.12.11/8.12.11) with ESMTP id lA8K5hXV074070 for ; Thu, 8 Nov 2007 21:05:43 +0100 (CET) (envelope-from philippe.lang@attiksystem.ch) Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: quote_nullable alternative? Date: Thu, 8 Nov 2007 21:05:43 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12 Message-ID: <6C0CF58A187DA5479245E0830AF84F4218CF6B@poweredge.attiksystem.ch> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: quote_nullable alternative? thread-index: AcgiQr9O7YsEW4KvSbuu4XWrZoij2w== From: "Philippe Lang" To: X-Scanned-By: MIMEDefang 2.49 on 10.0.0.111 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/30 X-Sequence-Number: 29558 Hi, There has been a recent discussion on the hacker mailing-list recently, regarding a new patch for postgresql, that returns 'NULL' instead of NULL when a NULL value is passed as a parameter. It's exactly what I need on my 8.2.5 server. Is there an alternative to patching the server in order to get that kind of feature, for example with plpgsql code? Because of that bug: http://www.postgresql.org/docs/faqs.FAQ.html#item4.19 ... I'm obliged to call EXECUTE at every temporary table call, and constructing the query string where parameters can be NULL is really a nightmare... Thanks Philippe Lang