SKUZZIE
DTDrizzle Team
•Created by SKUZZIE on 11/6/2024 in #help
Do prepared statement names matter?
Should we make sure that the names of prepared statements are unique in any way? If so, unique globally or within a block scope?
For example, is this a problem within the same block?
7 replies
DTDrizzle Team
•Created by SKUZZIE on 1/11/2024 in #help
Joining a subquery multiple times
Is there way to join a subquery multiple times?
For example, I have this subquery:
I'm trying to join the query once for the "current year" data, and again for the "previous year" data based on a date range.
1 replies
DTDrizzle Team
•Created by SKUZZIE on 12/14/2023 in #help
Upsert with multi-column unique index?
What is the correct way to do an upsert with a multi-column unique index?
I have this model:
And I'm trying to do an upsert like this:
But I'm getting the
duplicate key value violates unique constraint
error even though I have the target
of the onConflictDoUpdate
set to those two columns.
What am I doing wrong?28 replies