diff options
| -rw-r--r-- | src/parser/outfuncs.c | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/src/parser/outfuncs.c b/src/parser/outfuncs.c index c2ddf5e89..b02ffbaca 100644 --- a/src/parser/outfuncs.c +++ b/src/parser/outfuncs.c @@ -1535,7 +1535,14 @@ _outCommonTableExpr(String * str, CommonTableExpr *node) string_append_char(str, ") "); } - string_append_char(str, "AS ("); + string_append_char(str, "AS "); + + if (node->ctematerialized & CTEMaterializeAlways) + string_append_char(str, "MATERIALIZED "); + else if (node->ctematerialized & CTEMaterializeNever) + string_append_char(str, "NOT MATERIALIZED "); + + string_append_char(str, "("); _outNode(str, node->ctequery); string_append_char(str, ")"); } |