[BUG]: jsonb values are double-JSON.parse()'d on select #3018
Labels
Comments
|
to work around this for now, either create a import { customType } from "drizzle-orm/pg-core";
const jsonb = customType<{
data: unknown;
driverData: string;
config: undefined;
}>({
dataType() {
return `jsonb`;
},
fromDriver(value: string): unknown {
return value;
},
toDriver(value: unknown): string {
return JSON.stringify(value);
},
});OR remove import { types } from "pg";
types.setTypeParser(types.builtins.JSONB, (val) => val); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
What version of
drizzle-ormare you using?0.33.0
What version of
drizzle-kitare you using?0.23.0
Describe the Bug
I'm using drizzle + node postgres.
When I store a string e.g.
"10.5"under a jsonb column, I expect it to be returned as "10.5" in string format. Instead it's returned as 10.5This is probably because node-postgres does JSON.parse once, and then the jsonb column does it again.
Expected behavior
When I store a string e.g.
"10.5"under a jsonb column, I expect it to be returned as "10.5" in string format.Environment & setup
drizzle + node postgres
computer: macos
The text was updated successfully, but these errors were encountered: