Revision 12385
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 2300 | 2300 |
CREATE FUNCTION validation_views(schema text) RETURNS SETOF regclass |
| 2301 | 2301 |
LANGUAGE sql STABLE |
| 2302 | 2302 |
AS $_$ |
| 2303 |
SELECT * FROM util.show_views_like('^_[[:alpha:]]+_\d+_', $1)
|
|
| 2303 |
SELECT * |
|
| 2304 |
FROM util.show_views_like('^_[[:alpha:]]+_\d+_', util.str_equality_regexp($1))
|
|
| 2304 | 2305 |
$_$; |
| 2305 | 2306 |
|
| 2306 | 2307 |
|
Also available in: Unified diff
schemas/util.sql: show_views_like(): take a schema regexp like util.show_relations_like(), to allow matching views in all schemas