Revision 14101
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 4978 | 4978 |
CREATE FUNCTION view_is_subset(view_def text) RETURNS boolean |
| 4979 | 4979 |
LANGUAGE sql IMMUTABLE |
| 4980 | 4980 |
AS $_$ |
| 4981 |
SELECT util.view_is_automatically_updatable($1) AND $1 !~ '[()]' |
|
| 4981 |
SELECT util.view_is_automatically_updatable($1) AND $1 !~ '\y(?:WHERE)\y|[()]'
|
|
| 4982 | 4982 |
$_$; |
| 4983 | 4983 |
|
| 4984 | 4984 |
|
Also available in: Unified diff
bugfix: schemas/util.sql: view_is_subset(): auto-updatable views that are not plain subsets: include ones with WHERE clauses