Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 01DAF2E00CF for ; Fri, 22 Feb 2008 04:32:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 28884-05 for ; Fri, 22 Feb 2008 04:31:53 -0400 (AST) Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.190]) by postgresql.org (Postfix) with ESMTP id 43BD82E005B for ; Fri, 22 Feb 2008 04:31:56 -0400 (AST) Received: by rv-out-0910.google.com with SMTP id g13so235348rvb.43 for ; Fri, 22 Feb 2008 00:31:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:subject:date:message-id:mime-version:content-type:x-mailer:thread-index:content-language; bh=B0xya9JM5iNSz+kFOKu6Oi5tG3j8ckOxlVm9QQT9ZrQ=; b=gFkXFDIvC59bEcKjMjHdrqnT14GXSapbs/96lBsgMj8MvwtVjXqSKubCwDyLDbjD5Tr1Dp634K17UIuqq9USr8876kHvRi4TyICN4OUScAC5g5T+lDOnf8K7ucAgqEeWVhgrNeDsxspxxlZu41AIBDss0A3gMKPhpVfJIQgBH3M= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:subject:date:message-id:mime-version:content-type:x-mailer:thread-index:content-language; b=iVq4DYx/2LkEMnInd43b9M/JKZDLi041sQxu2X784N+cUgVrC9FLye26iFFlJbQEc/hRHYrG8cPXO9JgCnGpdgZo6AxB5NlMrVLlYdIC0t3q+N73ZiewYYqDS7igyys0wDMbgE3lPghDKzsUd2IXhjZwPZNMTw3sq5o3KfPg3j8= Received: by 10.140.139.3 with SMTP id m3mr7414070rvd.244.1203669115154; Fri, 22 Feb 2008 00:31:55 -0800 (PST) Received: from BITDLLT03 ( [122.162.21.57]) by mx.google.com with ESMTPS id c20sm2286537rvf.33.2008.02.22.00.31.52 (version=SSLv3 cipher=RC4-MD5); Fri, 22 Feb 2008 00:31:53 -0800 (PST) From: "Jyoti Seth" To: Subject: postgresql function not accepting null values in select statement Date: Fri, 22 Feb 2008 14:00:42 +0530 Message-ID: <001501c8752d$391c8e50$ab55aaf0$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0016_01C8755B.52D4CA50" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Ach1LTYOwQqhq33wRo2PYdHp74qGiw== Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/158 X-Sequence-Number: 30249 This is a multipart message in MIME format. ------=_NextPart_000_0016_01C8755B.52D4CA50 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, If I pass null value as the parameter of postgresql function, which is used in the where clause of select statement is not functioning properly. I have also changed the value of transform_null_equals = on in the conf file and restarted postgresql. But it is still giving error. Is there any possible solution. Thanks, Jyoti ------=_NextPart_000_0016_01C8755B.52D4CA50 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

If I pass null value as the parameter of postgresql = function, which is used in the where clause of select statement is not functioning properly.

 

I have also changed the value of transform_null_equals =3D = on in the conf file and restarted postgresql. But it is still giving error. =

 

Is there any possible solution.

 

Thanks,

Jyoti

------=_NextPart_000_0016_01C8755B.52D4CA50--