Revision 12334
Added by Aaron Marcuse-Kubitza over 10 years ago
util.sql | ||
---|---|---|
2527 | 2527 |
-- |
2528 | 2528 |
|
2529 | 2529 |
CREATE FUNCTION schema_matches(schema text, schema_regexp text) RETURNS boolean |
2530 |
LANGUAGE sql STABLE
|
|
2530 |
LANGUAGE sql IMMUTABLE
|
|
2531 | 2531 |
AS $_$ |
2532 | 2532 |
SELECT $1 ~ $2 AND /*in userspace*/$1 !~ '^(?:information_schema|pg_.*)$' |
2533 | 2533 |
$_$; |
Also available in: Unified diff
schemas/util.sql: schema_matches(): should be IMMUTABLE, not STABLE, because it uses only parameter values