Revision 12464
Added by Aaron Marcuse-Kubitza almost 11 years ago
trunk/schemas/util.sql | ||
---|---|---|
989 | 989 |
newline after to visually separate queries from one another. */ |
990 | 990 |
SELECT util.raise_notice($$ |
991 | 991 |
$$||$1||$$ |
992 |
$$||COALESCE($$ |
|
993 |
$$||util.explain2notice_msg_if_can($1)||$$ |
|
994 |
$$, '')) |
|
992 |
$$||COALESCE(util.explain2notice_msg_if_can($1), '')) |
|
995 | 993 |
$_$; |
996 | 994 |
|
997 | 995 |
|
... | ... | |
1455 | 1453 |
CREATE FUNCTION explain2notice_msg(sql text) RETURNS text |
1456 | 1454 |
LANGUAGE sql |
1457 | 1455 |
AS $_$ |
1458 |
SELECT $$EXPLAIN: |
|
1459 |
$$||util.explain2str($1) |
|
1456 |
-- newline before and after to visually separate it from other debug info |
|
1457 |
SELECT $$ |
|
1458 |
EXPLAIN: |
|
1459 |
$$||util.explain2str($1)||$$ |
|
1460 |
$$ |
|
1460 | 1461 |
$_$; |
1461 | 1462 |
|
1462 | 1463 |
|
Also available in: Unified diff
schemas/util.sql: util.explain2notice_msg(): add newline before and after to visually separate it from other debug info