Skip to content
This repository has been archived by the owner on Feb 24, 2024. It is now read-only.

Remove and warn about STRICT in functions #224

Open
steve-chavez opened this issue Jun 22, 2019 · 2 comments
Open

Remove and warn about STRICT in functions #224

steve-chavez opened this issue Jun 22, 2019 · 2 comments
Labels
references Technical reference.

Comments

@steve-chavez
Copy link
Member

Related to PostgREST/postgrest#1294.
@steve-chavez steve-chavez mentioned this issue Jun 22, 2019
Closed
@steve-chavez
Copy link
Member Author

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.

steve-chavez added a commit to steve-chavez/postgrest-docs that referenced this issue Aug 1, 2019
@steve-chavez
Fix PostgREST#224, remove STRICT from example rpc
9b36102
@steve-chavez steve-chavez added the references Technical reference. label Aug 15, 2019
steve-chavez added a commit to steve-chavez/postgrest-docs that referenced this issue Aug 19, 2019
@steve-chavez
Fix PostgREST#224, remove STRICT from example rpc
a78892f
@steve-chavez
Copy link
Member Author

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

@steve-chavez steve-chavez reopened this Jul 28, 2021
@wolfgangwalther wolfgangwalther mentioned this issue Feb 20, 2024
Open
3 tasks
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
references Technical reference.
Milestone
No milestone
Development

No branches or pull requests
1 participant
@steve-chavez