Revision 14286
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 5996 | 5996 |
CREATE FUNCTION view_is_subset(view_def text) RETURNS boolean |
| 5997 | 5997 |
LANGUAGE sql IMMUTABLE |
| 5998 | 5998 |
AS $_$ |
| 5999 |
SELECT util.view_is_automatically_updatable($1) AND $1 !~ '\y(?:WHERE)\y|[()]' |
|
| 5999 |
SELECT util.view_is_automatically_updatable($1) |
|
| 6000 |
AND $1 !~ '\y(?:WHERE)\y|\([^-]|[^-]\)' -- "(-x-)" in col name is OK |
|
| 6000 | 6001 |
$_$; |
| 6001 | 6002 |
|
| 6002 | 6003 |
|
Also available in: Unified diff
bugfix: schemas/util.sql: view_is_subset(): need to support "(
x)" in col name