Revision 14263
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 867 | 867 |
|
| 868 | 868 |
CREATE FUNCTION canon_sql(expr text, table_ regtype DEFAULT NULL::regtype) RETURNS text |
| 869 | 869 |
LANGUAGE sql STABLE |
| 870 |
SET search_path TO pg_temp |
|
| 870 | 871 |
AS $_$ |
| 871 | 872 |
-- **IMPORTANT**: need to remove the enclosing () to be consistent everywhere |
| 872 | 873 |
SELECT util.trim_parens((regexp_matches(line, |
Also available in: Unified diff
bugfix: schemas/util.sql: canon_sql(): need to use the right search_path