How to pass an array without casting?

[mmkal]

Currently I am doing this to pass an array of jsonb:

test('jsonb array', async () => {
  await db.query(`drop table if exists jsonb_array_test`)
  await db.query(`create table jsonb_array_test(id int, jsons jsonb[])`)

  const values = [{n: 'one'}, {n: 'two'}, {n: 'three'}]

  const result = await db.query(
    `
      insert into jsonb_array_test
      values (1, $1::jsonb[])
      returning *
    `,
    [values.map(v => JSON.stringify(v))],
  )

  expect(result).toEqual([{id: 1, jsons: values}])
})

Is there a better way to do this though? I am worried that pg-promise is creating a pointless array of type text[] and then my SQL is casting it to jsonb[] which might be wasteful.

Note: in the context I don't want to use :csv or :list, I want to pass an actual postgresql array.

[vitaly-t]

Can you clarify what you expect the resulting query to look like?

[mmkal]

Good question - I had made a bad assumption that it was pg-promise casting my array to text[] but it seems not, having actually logged the query. I think the example I gave above is fine (just doing $1::jsonb[]).