postgresql function not accepting null values in select statement - Mailing list pgsql-sql

From Jyoti Seth
Subject postgresql function not accepting null values in select statement
Date
Msg-id 001501c8752d$391c8e50$ab55aaf0$@com
Whole thread Raw
Responses Re: postgresql function not accepting null values in select statement
List 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

pgsql-sql by date:

Previous
From: "Phillip Smith"
Date:
Subject: Re: Proposed archival read only trigger on rows - prevent history modification
Next
From: Richard Huxton
Date:
Subject: Re: postgresql function not accepting null values in select statement