Revision 11833
Added by Aaron Marcuse-Kubitza about 11 years ago
| schemas/util.sql | ||
|---|---|---|
| 1104 | 1104 |
|
| 1105 | 1105 |
|
| 1106 | 1106 |
-- |
| 1107 |
-- Name: explain2notice(text); Type: FUNCTION; Schema: util; Owner: - |
|
| 1108 |
-- |
|
| 1109 |
|
|
| 1110 |
CREATE FUNCTION explain2notice(sql text) RETURNS void |
|
| 1111 |
LANGUAGE plpgsql |
|
| 1112 |
AS $_$ |
|
| 1113 |
BEGIN |
|
| 1114 |
RAISE NOTICE '%', $$EXPLAIN: |
|
| 1115 |
$$||util.explain2str(sql); |
|
| 1116 |
END; |
|
| 1117 |
$_$; |
|
| 1118 |
|
|
| 1119 |
|
|
| 1120 |
-- |
|
| 1107 | 1121 |
-- Name: explain2str(text); Type: FUNCTION; Schema: util; Owner: - |
| 1108 | 1122 |
-- |
| 1109 | 1123 |
|
Also available in: Unified diff
schemas/util.sql: added explain2notice()