32 replies

Why is 1 and 0 are returned as string?

With the following:

isUsed: sql<boolean>`case when ${usedExchanges.data} is not null then 1 else 0 end`

isUsed: sql<boolean>`case when ${usedExchanges.data} is not null then 1 else 0 end`

I get

isUsed

isUsed

"1"

"1"

"0"

"0"

whereas I would expect a boolean.

Drizzle Team Join

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

11,879Members

Resources

Similar Threads

Was this page helpful?

Twitter GitHub Discord

Communities Docs About Terms Privacy

Star

Setup for Free

Drizzle Team•3y ago•

32 replies

binajmen

Why is 1 and 0 are returned as string?

With the following:

isUsed: sql<boolean>`case when ${usedExchanges.data} is not null then 1 else 0 end`

isUsed: sql<boolean>`case when ${usedExchanges.data} is not null then 1 else 0 end`

I get

isUsed

isUsed

"1"

"1"

"0"

"0"

whereas I would expect a boolean.

Drizzle Team Join

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

11,879Members

Resources

DTDrizzle Team / help

3y ago

Numeric // Decimal Postgres types are inferred as strings and expect string as an input as well

DTDrizzle Team / help

3y ago

date column not being returned as string by drizzle

DTDrizzle Team / help

3y ago

latitude and longitude are string type but were defined as numeric

DTDrizzle Team / help

2y ago

Similar Threads

Was this page helpful?

Recent Announcements

DTDrizzle Team / help

3y ago

Numeric // Decimal Postgres types are inferred as strings and expect string as an input as well

DTDrizzle Team / help

3y ago

date column not being returned as string by drizzle

DTDrizzle Team / help

3y ago

latitude and longitude are string type but were defined as numeric

DTDrizzle Team / help

2y ago