Query that searches for value in array
user_to_account:
• id: integer
• user_id: integer
• account_id: integer
• roles: array[ ]
Is it possible to to run a query database table that searches the roles[ ] field for something like 'Super Admin'?
I know how to do this with the array functions, but is it possible to do it with just one query.
Working with APIs
1 reply