REST from your database catalog
    DocumentationCheat sheetQuestionsDownloadSource
    Questions
    • How do I...?
    Start here
    • Getting started
    • What a table becomes
    • Compared with PostgREST
    Setting up
    • Tables, columns and relations
    • Security and hooks
    • Writes and procedures
    • Prefer: return=representation
    • Node, Fastify, Express
    Reading
    • select
    • /{key}
    • relation(...)
    • order
    • limit, offset
    • relation.order, .limit
    • count
    • count(), sum(), avg()...
    • "name"
    Filtering
    • eq, neq
    • gt, gte, lt, lte
    • in
    • like, ilike
    • match, imatch
    • is
    • ov, cs, cd
    • not
    • relation.column
    • or, and
    Databases
    • Supported databases
    • Adding a database
    Reference
    • Cheat sheet
    • Errors
    Filtering

    Array overlap and containment

    Compare an array column with a list: overlaps, contains, contained by.

    PostgreSQL only
    labels=ov.{a,b}labels=cs.{a}labels=cd.{a,b,c}

    These apply to array columns. ov keeps an array sharing at least one item with the list, cs one holding every item of it, cd one whose items are all in it.

    On any other column they answer bad_operator, as the example shows: a todo's name is text, not an array.

    Examples

    Text is not an array.
    /todos?select=name&name=ov.{a}

    Asking the database...

    See alsoOne of a list
    PreviousNull, true, false, emptyNext Turn a filter around
    restloom - a REST API generated from your database catalog
    DocumentationDownloadSource