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  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: "Phillip Smith"
Дата:
Сообщение: Re: Proposed archival read only trigger on rows - prevent history modification
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: postgresql function not accepting null values in select statement