-
Notifications
You must be signed in to change notification settings - Fork 32
Closed
Description
I'm trying to create an aggregate like this
CREATE AGGREGATE json_agg_strict(anyelement)(
SFUNC = json_agg_strict_sfunc,
STYPE = jsonb,
FINALFUNC = json_agg_strict_finalfunc,
INITCOND = '[]'
);But it deparses to (added newlines for clarity)
CREATE AGGREGATE json_agg_strict ( anyelement ) (
sfunc = json_agg_strict_sfunc ,
stype = jsonb ,
finalfunc = json_agg_strict_finalfunc ,
initcond = []
);
^ it should be initcond = '[]'
Below is how to reproduce
> const parser = require("pgsql-parser")
undefined
> const query = `
... CREATE AGGREGATE json_agg_strict(anyelement)(
... SFUNC = json_agg_strict_sfunc,
... STYPE = jsonb,
... FINALFUNC = json_agg_strict_finalfunc,
... INITCOND = '[]'
... );
... `;
undefined
> parser.deparse(parser.parse(query))
'CREATE AGGREGATE json_agg_strict ( anyelement ) ( sfunc = json_agg_strict_sfunc , stype = jsonb , finalfunc = json_agg_strict_finalfunc , initcond = [] );'
Metadata
Metadata
Assignees
Labels
No labels