K
Kyselymike

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)
Want results from more Discord servers?
Add your server
More Posts
Partial compileHello everyone, is it possible (somehow) to generate only part of the compiled query? I have an edgeQuerying on jsonArrayFromHi. So i need to fetch posts with comments from a database that are written by a set group of authorWhy does `.stream()` return a single result when I pass in a `chunkSize` option ?I'm guessing it returns `chunkSize` mount of rows for each iteration, but shouldn't it be an array iIs there a way to keep full date precision?It appears that selecting dates from Postgresql loses some precision, which wreaks havoc with my pag