Remove and warn about STRICT in functions

Open steve-chavez opened this issue 6 years ago • 2 comments

Related to https://github.com/PostgREST/postgrest/issues/1294.

Jun 22 '19 00:06 steve-chavez

The definition of STRICT:

STRICT indicates that the function always returns null whenever any of its arguments are null. If this parameter is specified, the function is not executed when there are null arguments; instead a null result is assumed automatically.

Personally I never use it. I think I'll just remove the keyword, if I go into details of the performance implications the note could get too long.

Aug 01 '19 18:08 steve-chavez

I think this recommendation should go in our schema structure now.

Jul 28 '21 06:07 steve-chavez