Postgres Pro
Downloads
Home   >   mailing lists

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  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Tree view 
<div class="Section1"><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"MS Reference Sans
Serif","sans-serif";
color:green">Hi,</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"MS Reference Sans
Serif","sans-serif";
color:green"> </span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"MS Reference Sans
Serif","sans-serif";
color:green">If I pass null value as the parameter of postgresql function, which is used in the where clause of select
statementis not functioning properly.</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"MS
ReferenceSans Serif","sans-serif"; 
color:green"> </span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"MS Reference Sans
Serif","sans-serif";
color:green">I have also changed the value of transform_null_equals = on in the conf file and restarted postgresql. But
itis still giving error. </span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"MS Reference Sans
Serif","sans-serif";
color:green"> </span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"MS Reference Sans
Serif","sans-serif";
color:green">Is there any possible solution.</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"MS
ReferenceSans Serif","sans-serif"; 
color:green"> </span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"MS Reference Sans
Serif","sans-serif";
color:green">Thanks,</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"MS Reference Sans
Serif","sans-serif";
color:green">Jyoti </span></div>

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