On Wed, Jun 3, 2009 at 9:45 AM, Gevik Babakhani <pgdev(at)xs4all(dot)nl> wrote:
> Could someone please clarify the difference between "RETURNS NULL ON NULL
> INPUT" or "STRICT" when creating a function.
They're synonyms.
> Do both options exist because
> of historical reasons/SQL standard compliance?
One or the other, not sure which.
> Shouldn't we raise an error when calling a function with NULL arguments
> values if the function is created as STRICT?
No, what they do is return NULL automatically. The function doesn't
have to check for NULL arguments itself.
--
greg