1 reply

Issue with JSON Array Parameter in PgClient Merge Query

i'm trying to use PgClient to do a bulk upsert with a merge query, using

jsonb_to_recordset

jsonb_to_recordset

to feed in my inputs with a single prepared param (

JSON.stringify(arrayOfRecordsMatchingTableRow)

JSON.stringify(arrayOfRecordsMatchingTableRow)

) - whatever the tagged template literal interface to the client is doing to the param here is causing pg to not see it as a JSON array (seems likely formatted as a single string value).

is there something i can do to get this to work as intended?

`select * from jsonb_to_recordset(${JSON.stringify(values)}::jsonb) as`

`select * from jsonb_to_recordset(${JSON.stringify(values)}::jsonb) as`

Effect Community•8mo ago•

1 reply

beezee

Issue with JSON Array Parameter in PgClient Merge Query

i'm trying to use PgClient to do a bulk upsert with a merge query, using

jsonb_to_recordset

jsonb_to_recordset

to feed in my inputs with a single prepared param (

JSON.stringify(arrayOfRecordsMatchingTableRow)

JSON.stringify(arrayOfRecordsMatchingTableRow)

`select * from jsonb_to_recordset(${JSON.stringify(values)}::jsonb) as`

`select * from jsonb_to_recordset(${JSON.stringify(values)}::jsonb) as`

Issue with JSON Array Parameter in PgClient Merge Query

Similar Threads

Issue with JSON Array Parameter in PgClient Merge Query

Similar Threads

Similar Threads

Similar Threads