How to Access an array of strings in jsonb format
I am trying to find records where slug (predefined variable) is found in an array in my jsonb players column. The value looks like this:
['John', 'James', 'Joe', 'Jack']
If slug = John then this should return the record.
My below query does not work:
const result = await db.execute(
sql
);
I get this error:
ERROR: operator does not exist: jsonb ? record
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
Any suggestions would be really helpful
['John', 'James', 'Joe', 'Jack']
If slug = John then this should return the record.
My below query does not work:
const result = await db.execute(
sql
SELECT * FROM ${table} WHERE ${table.players}::jsonb ? ${slug});
I get this error:
ERROR: operator does not exist: jsonb ? record
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
Any suggestions would be really helpful
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Similar Threads
Was this page helpful?
