/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 14188

schemas/util.sql: remove_prefix(), remove_suffix(): use new starts_with(), ends_with()

         AS $$
     -- must be declared STRICT to handle NULL properly
     SELECT CASE
     WHEN substring(str from 1 for length(prefix)) = prefix THEN
     WHEN util.starts_with(prefix, str) THEN
     	substring(str from 1+length(prefix))
     WHEN NOT require THEN str
     ELSE
-...
         AS $$
     -- must be declared STRICT to handle NULL properly
     SELECT CASE
     WHEN substring(str from 1+(length(str)-length(suffix))) = suffix THEN
     WHEN util.ends_with(suffix, str) THEN
     	substring(str from 1 for length(str)-length(suffix))
     WHEN NOT require THEN str
     ELSE

Also available in: Unified diff