我正在try 编写一个UPDATE查询来更新所有拥有一只名为"Mark"的狗的用户,该表有一个名为"Additional_Options"的列,它是一个Json BLOB,如下所示
{
'dog_name': 'Mark'
}
现在我有
update "Employees" e set country = "BR" where json_extract_path(e.additional_options, "dog_name") = "Mark"
我使用这个postgres functions found here来构建它,但现在我得到一个错误
column "dog_name" does not exist
有没有人能帮我弄清楚为什么这不管用?
编辑: 如果它有帮助,我使用Prisma编写了这个查询,并且它起作用了
export const moveToBrazil = async(): Promise<Employee[]> => {
await db.employees.updateMany({
where: {
additional_options: {
path: ['dog_name'],
equals: 'Ellie'
}
},
data: {
country: "BR"
}
});
return db.employees.findMany({
where: {
additional_options: {
path: ['dog_name'],
equals: 'Ellie'
}
},
});
}