© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•3y ago•
3 replies
Screw

Using arrayContains with a jsonb postgres type

arrayContains(matches.teamA, [id])
arrayContains(matches.teamA, [id])


teamA is a jsonb type of
string[]
string[]
i want to see if the id exists inside whats the best way of doing this
Drizzle TeamJoin
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?
Recent Announcements

Similar Threads

JsonB and $type
Drizzle TeamDTDrizzle Team / help
11mo ago
Invalid Byte Encoding with Postgres JSONB columns
Drizzle TeamDTDrizzle Team / help
2y ago
drizzle-zod not infering jsonb type properly
Drizzle TeamDTDrizzle Team / help
2y ago
Making a key in a object with jsonb unique
Drizzle TeamDTDrizzle Team / help
2y ago