Revision 12665
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.sql | ||
|---|---|---|
| 3634 | 3634 |
CREATE FUNCTION validation_views(schema text DEFAULT NULL::text) RETURNS SETOF regclass |
| 3635 | 3635 |
LANGUAGE sql STABLE |
| 3636 | 3636 |
AS $_$ |
| 3637 |
SELECT * FROM util.show_views_like('^_[[:alpha:]]+_\d+_', (CASE WHEN $1 IS NULL
|
|
| 3637 |
SELECT * FROM util.show_views_like('^_[[:alpha:]]+_\d+', (CASE WHEN $1 IS NULL
|
|
| 3638 | 3638 |
THEN ''/*all schemas*/ ELSE util.str_equality_regexp($1) END)) |
| 3639 | 3639 |
$_$; |
| 3640 | 3640 |
|
Also available in: Unified diff
bugfix: schemas/vegbien.sql: public_validations.validation_views(): need to include views with letters after the query # (eg. _plots_06a_list_of_stems)