postgresql function not accepting null values in select statement

From: "Jyoti Seth" <jyotiseth2001(at)gmail(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: postgresql function not accepting null values in select statement
Date: 2008-02-22 08:30:42
Message-ID: 001501c8752d$391c8e50$ab55aaf0$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2008-02-22 09:05:28 Re: postgresql function not accepting null values in select statement
Previous Message Phillip Smith 2008-02-22 04:09:11 Re: Proposed archival read only trigger on rows - prevent history modification