postgresql function not accepting null values in select statement
От | Jyoti Seth |
---|---|
Тема | postgresql function not accepting null values in select statement |
Дата | |
Msg-id | 001501c8752d$391c8e50$ab55aaf0$@com обсуждение исходный текст |
Ответы |
Re: postgresql function not accepting null values in select
statement
|
Список | pgsql-sql |
<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 по дате отправления: