Ilan Yehezkely
Explore posts from serversDTDrizzle Team
•Created by Ilan Yehezkely on 4/12/2024 in #help
Is this the correct way to use With clause (CTEs) to delete a row using only one transaction?
ok I see now, thank you for the explanations and examples 👏
14 replies
DTDrizzle Team
•Created by Ilan Yehezkely on 4/12/2024 in #help
Is this the correct way to use With clause (CTEs) to delete a row using only one transaction?
And it has the same performance as with the first option (with/as)? How can I test how many transactions are running per query?
14 replies
DTDrizzle Team
•Created by Ilan Yehezkely on 4/12/2024 in #help
Is this the correct way to use With clause (CTEs) to delete a row using only one transaction?
You didn't use the .with() on the return query, why?
14 replies
DTDrizzle Team
•Created by Ilan Yehezkely on 4/12/2024 in #help
Is this the correct way to use With clause (CTEs) to delete a row using only one transaction?
Oh, the alternative looks much more friendly, it should work the same?
14 replies
DTDrizzle Team
•Created by Ilan Yehezkely on 4/12/2024 in #help
Is this the correct way to use With clause (CTEs) to delete a row using only one transaction?
Why do you need to run "SELECT * FROM" instead of just running the query: sql
(${userId})?14 replies
DTDrizzle Team
•Created by Ilan Yehezkely on 4/12/2024 in #help
Is this the correct way to use With clause (CTEs) to delete a row using only one transaction?
Thank you very much for the help
14 replies
DTDrizzle Team
•Created by Ilan Yehezkely on 4/12/2024 in #help
Is this the correct way to use With clause (CTEs) to delete a row using only one transaction?
Oh, it returns a query, so I'm actually running multiple queries from a single query, that makes sense 🙂 I wish there were more examples like this for these options in the docs especially when it's a more advanced option.
14 replies