K
Kysely9mo ago
mike

how to write not (array1 && array2)

Hi again, how to write following code? I would love to use not(expression) Expected result:
not('{US,UK,AR}' && my_table.allowed_countries)
not('{US,UK,AR}' && my_table.allowed_countries)
raw attempt:
sql`not('{ ${array1.join(',')} }') && ref('my_table.allowed_countries')
sql`not('{ ${array1.join(',')} }') && ref('my_table.allowed_countries')
but it produces:
not('{'US,UK,AR'}') && my_table.allowed_countries)
not('{'US,UK,AR'}') && my_table.allowed_countries)
0 Replies
No replies yetBe the first to reply to this messageJoin
Want results from more Discord servers?
Add your server