I'm trying to pass an array of numbers into an UPDATE query. I tried this:
const ids = [0,1,2];
await sql`
UPDATE scheduled_notifications
SET last_sent_at = NOW()
WHERE id = ANY(${ids}::bigint[])
`;
but TypeScript doesn't like that "ids" is a "number[]" and not a "Primitive."
What should I do instead?
Please & thank you!
I'm trying to pass an array of numbers into an UPDATE query. I tried this:
but TypeScript doesn't like that "ids" is a "number[]" and not a "Primitive."
What should I do instead?
Please & thank you!