DefineStmt is not implemented

[divyenduz]

To reproduce

const stmts = parse(`
    CREATE AGGREGATE group_concat(text) (
        SFUNC = _group_concat,
        STYPE = text
    );
`)
console.log(stmts)
deparse(stmts[0])

Source database https://github.com/prisma/database-schema-examples/blob/main/postgres/sakila/schema.sql

I ran it on all the databases here https://github.com/prisma/database-schema-examples/tree/main/postgres and this was the only error we got 🎉

[pyramation]

thanks! Looking at this one and pasting AST for reference

[
  {
    "RawStmt": {
      "stmt": {
        "DefineStmt": {
          "kind": "OBJECT_AGGREGATE",
          "defnames": [
            {
              "String": {
                "str": "group_concat"
              }
            }
          ],
          "args": [
            {
              "List": {
                "items": [
                  {
                    "FunctionParameter": {
                      "argType": {
                        "names": [
                          {
                            "String": {
                              "str": "text"
                            }
                          }
                        ],
                        "typemod": -1,
                        "location": 30
                      },
                      "mode": "FUNC_PARAM_IN"
                    }
                  }
                ]
              }
            },
            {
              "Integer": {
                "ival": -1
              }
            }
          ],
          "definition": [
            {
              "DefElem": {
                "defname": "sfunc",
                "arg": {
                  "TypeName": {
                    "names": [
                      {
                        "String": {
                          "str": "_group_concat"
                        }
                      }
                    ],
                    "typemod": -1,
                    "location": 54
                  }
                },
                "defaction": "DEFELEM_UNSPEC",
                "location": 46
              }
            },
            {
              "DefElem": {
                "defname": "stype",
                "arg": {
                  "TypeName": {
                    "names": [
                      {
                        "String": {
                          "str": "text"
                        }
                      }
                    ],
                    "typemod": -1,
                    "location": 85
                  }
                },
                "defaction": "DEFELEM_UNSPEC",
                "location": 77
              }
            }
          ]
        }
      },
      "stmt_len": 95
    }
  }
]

[pyramation]

should be good to go now! Please let me know if you find other issues, thanks again!

 - pgsql-deparser@13.1.11
 - pgsql-parser@13.1.11