I’m triying to use EXCEPT in a prisma project, but I don’t see any documentation of it in the official site.
I need, for example:
SELECT * FROM TABLE_A
EXCEPT
SELECT * FROM TABLE_B
It’s that possible with prisma?
I’m using a raw query rigth now. But with prisma sentences it would be easy to work.
I face similar problem. I used something like below as an alternative as Prisma does not support using EXCEPT directly.
const result = await prisma.$queryRawSELECT * FROM TABLE_A EXCEPT SELECT * FROM TABLE_B;
console.log(result);
New contributor
swawge is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1