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)

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')

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)

not('{'US,UK,AR'}') && my_table.allowed_countries)

not('{'US,UK,AR'}') && my_table.allowed_countries)

No replies yetBe the first to reply to this messageJoin