how to use booleans in dizzle?
i have succesfully followed the drizzle docs on how to use booleans but i get a weird error:
Type 'MySqlBooleanBuilderInitial<"isFeatured">' is not assignable to type 'PgColumnBuilderBase<ColumnBuilderBaseConfig<ColumnDataType, string>, object>'.
The types of '_.dialect' are incompatible between these types.
Type '"mysql"' is not assignable to type '"pg"'.ts(2322)
here is my table: export const articles = pgTable("p_articles", {
id: serial("id").primaryKey(),
userId: text("userId")
.notNull()
.references(() => users.id, { onDelete: "cascade" }),
title: text("title").notNull(),
description: text("description").notNull(),
isFeatured: boolean("isFeatured"),
imageUrl: text("imageUrl").notNull(),
createdDate: timestamp("timestamp", { mode: "date" }).notNull(),
});
2 Replies
have you imported boolean from mysql instead of pg ?
oh yea i imported it two places thank you