sql db_postgres update where in (…………)

2022-12-17 Thread jiep
thank you both, i'll go with ThomasTJdev's at the moment. i was not far, i didn't dig enough to see sql**( **< query>**)** i saw only sql**" **< query>**"** so i tried to join and insert with ? but an error occured. i also forgot about & and was thinking about trying with fmt but i buged on how

sql db_postgres update where in (…………)

2022-12-16 Thread jiep
hello, i looked around but didn't find clues how do i create a query with an IN ( ?, ? , ………) , @[element x, element x+1………, element x + n] db.exec(sql"update table set = ? where IN (?,)", el, @[]) i will work on a table with 200 000 lines, if i have to update them one by one i gonna lose ho