Unable to create a check constraint for NaN values
I am working to prevent any chance of NaN from being inserted into my DB, so I created a check constraint that looks like the following:
(table) => [
check("fancy_check_name", sql
],
When I run drizzle-kit's push method, I get the following error, "error: column "nan" does not exist"
Any combination of quotes or anything around NaN makes no difference.
Any Ideas?
(table) => [
check("fancy_check_name", sql
${table.amount} <> NaN),],
When I run drizzle-kit's push method, I get the following error, "error: column "nan" does not exist"
Any combination of quotes or anything around NaN makes no difference.
Any Ideas?
