/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 12385

schemas/util.sql: show_views_like(): take a schema regexp like util.show_relations_like(), to allow matching views in all schemas

     -- Name: show_views_like(text, text); Type: FUNCTION; Schema: util; Owner: -
     --
     CREATE FUNCTION show_views_like(name_regexp text, schema text) RETURNS SETOF regclass
     CREATE FUNCTION show_views_like(name_regexp text, schema_regexp text DEFAULT ''::text) RETURNS SETOF regclass
         LANGUAGE sql STABLE
         AS $_$
     SELECT view_
     FROM util.show_relations_like($1, types := ARRAY['v']) view_
     WHERE util.schema(view_) = $2
     SELECT * FROM util.show_relations_like($1, $2, ARRAY['v'])
     $_$;

     CREATE FUNCTION validation_views(schema text) RETURNS SETOF regclass
         LANGUAGE sql STABLE
         AS $_$
     SELECT * FROM util.show_views_like('^_[[:alpha:]]+_\d+_', $1)
     SELECT *
     FROM util.show_views_like('^_[[:alpha:]]+_\d+_', util.str_equality_regexp($1))
     $_$;

Also available in: Unified diff