Question about STRICT
От | Gevik Babakhani |
---|---|
Тема | Question about STRICT |
Дата | |
Msg-id | 4A263838.3020405@xs4all.nl обсуждение исходный текст |
Ответы |
Re: Question about STRICT
|
Список | pgsql-hackers |
<p class="MsoNormal">Could someone please clarify the difference between <tt><span lang="EN" style="font-size: 10pt; line-height:115%; color: black;">"RETURNS NULL ON NULL INPUT</span></tt><span lang="EN" style="font-size: 9pt; line-height:115%; font-family: "Verdana","sans-serif"; color: black;">" or "</span><tt><span lang="EN" style="font-size:10pt; line-height: 115%; color: black;">STRICT" when creating a function. Do both options exist becauseof historical reasons/SQL standard compliance?<br /></span></tt><p class="MsoNormal"><tt><span lang="EN" style="font-size:10pt; line-height: 115%; color: black;"><br /> Shouldn't we raise an error when calling a function withNULL arguments values if the function is created as STRICT?<br /> (This would of course have an impact on checking forNULLs on arguments defaults if the above is implemented.)</span></tt><br /><p class="MsoNormal">-- <br /><pre class="moz-signature"cols="72">Regards, Gevik</pre>
В списке pgsql-hackers по дате отправления: