Error while trying to insert an json array

[eriknyk]

Hi, this issue #442 should be reopened, since in postgres shell is possible to execute without problems:

INSERT INTO public.my_table (userId, personId, books) VALUES (1, 1, '[1,2,3]');

however when trying to insert the same array using pg module I'm getting the error:

"error": {
    "cause": {
      "message": "invalid input syntax for type json",
      "code": "22P02",
      "detail": "Expected \":\", but found \",\".",
      "length": 148,
      "severity": "ERROR",
      "where": "JSON data, line 1: {\"1\",...",
      "file": "json.c",
      "line": "1198",
      "routine": "report_parse_error"
    },
    "isOperational": true,
    "code": "22P02",
    "detail": "Expected \":\", but found \",\".",
    "length": 148,
    "severity": "ERROR",
    "where": "JSON data, line 1: {\"1\",...",
    "file": "json.c",
    "line": "1198",
    "routine": "report_parse_error"
  }

Best Regards

[joskuijpers]

Could you give your Table layout so we could try to reproduce this error?

[brianc]

This looks like a syntax error with your query & not a bug with node-postgres. Particularly in the case of a plain text query without parameters the query is passed 100% unaltered to the backend server.

[dcworldwide]

@brianc Just to confirm, is what the OP asked supported? I.e. inserting an array (not a object) into a JSON/B column?

I'm having an issue inserting an array into a JSON column with typeorm. It's a library that depends on this library for postgres integration. I want to know if it's a bug in that library, or a limitation of this library. Thanks

typeorm/typeorm#183

[charmander]

@dcworldwide See #1143.