/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 13386

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: query_view_regexp(): also match auxiliary tables

     CREATE FUNCTION query_view_regexp() RETURNS text
         LANGUAGE sql IMMUTABLE
         AS $$
     SELECT '^_[[:alpha:]]+_\d+'::text
     SELECT '^(?:_[[:alpha:]]+_)?_[[:alpha:]]+_\d+'::text
     $$;

     CREATE FUNCTION query_view_regexp() RETURNS text
         LANGUAGE sql IMMUTABLE
         AS $$
     SELECT '^_[[:alpha:]]+_\d+'::text
     SELECT '^(?:_[[:alpha:]]+_)?_[[:alpha:]]+_\d+'::text
     $$;

Also available in: Unified diff