Stefan Stefanov

Great! Here is a REST service template (working) that might be useful for the documentation, in two flavours - - using separate method implementation files (file "Using run_sql.sql") - using...

"email" format validation may be added with one extra line in the `case` list that uses the popular regular expression: ```sql WHEN 'email' THEN IF target !~* '^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$' THEN RAISE;...

Fair enough, exception handling does add some overhead. Yet given the relative complexity of regular expressions and ISO8601 validation (620+ timezone names and abbreviations) I think that this is a...

Validating 100K `{"type":"number"}` with commented `"format"` section (i.e. the original function with no exception handling code) took the same 11.3 s. There is no performance change unless `{"type":"string", "format":"date-time"}` is...

> > "email" format validation may be added with one extra line in the `case` list that uses the popular regular expression: > > ```sql > > WHEN 'email' THEN...