Kysely•12mo ago

bool_or

Hi, How to use bool_or ? I am using it in case-when-then construction. https://www.postgresql.org/docs/8.4/functions-aggregate.html

PostgreSQL Documentation

1 Reply

mike•12mo ago

I did this way after all - hoping it's how it should be...

eb
    .case()
    .when(
        sql<boolean>`bool_or(${eb.ref(
            'MyTable.unlimited',
        )})`,
    )
    .then(-1)

eb
    .case()
    .when(
        sql<boolean>`bool_or(${eb.ref(
            'MyTable.unlimited',
        )})`,
    )
    .then(-1)