Unimplemented TRAILING function

[ThiBsc]

Describe the bug

Have a typeorm migration trying to use the trailing function of postgres

QueryFailedError: 💔 Your query failed to parse.
    This is most likely due to a SQL syntax error. However, you might also have hit a bug, or an unimplemented feature of pg-mem.
    If this is the case, please file an issue at https://github.com/oguimbal/pg-mem along with a query that reproduces this syntax error.

    👉 Failed query:

        UPDATE "mytable" SET guid = TRIM(TRAILING chr(10) FROM guid) WHERE guid LIKE '%' || chr(10);

    💀 Syntax error at line 1 col 30:

    1  UPDATE "mytable" SET guid = TRIM(TRAILING chr(10) FROM guid) WHERE guid LIKE '%' || chr(10);

pg-mem version

# output of:
cat ./node_modules/pg-mem/package.json | grep version

# "version": "3.0.5",
# "description": "A memory version of postgres"

[ThiBsc]

My temporary workaround:

Rewrite the query like this:

UPDATE "mytable" SET guid = REPLACE(guid, CHR(10), '') WHERE LENGTH(guid) != LENGTH(REPLACE(guid, CHR(10), ''));

Then register functions:

memoryDb.public.registerFunction({
  name: 'length',
  args: [DataType.text],
  returns: DataType.integer,
  implementation: (str: string) => str.length,
});

memoryDb.public.registerFunction({
  name: 'chr',
  args: [DataType.integer],
  returns: DataType.text,
  implementation: (code: number) => String.fromCharCode(code),
});

memoryDb.public.registerFunction({
  name: 'replace',
  args: [DataType.text, DataType.text, DataType.text],
  returns: DataType.text,
  implementation: (str: string, search: string, replacement: string) => {
    return str.replace(new RegExp(search, 'g'), replacement);
  },
});