On Wed, Jun 3, 2009 at 9:45 AM, Gevik Babakhani <pg...@xs4all.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
