How to compare a UUID field

[t-indie]

Firstly, thank you so much for maintaining this project and providing the insightful example

I have a PostgreSQL users table where the id is of type UUID, however when I use the where comparator I get this error "operator does not exist: uuid = character varying"

export async function findUserById(
    db: Kysely<Database>,
    id: string
): Promise<UserRow | undefined> {
    const user = await db
        .selectFrom(tableName)
        .where('id', '=', id)
        .selectAll(tableName)
        .executeTakeFirst();
    return user;
}

I found online that one should use this operator but unfortunately it throws an error

.where('id::text', '=', id)

Any ideas would be appreciated. Thanks in advance

[koskimas]

Either like this

.where(sql`id::text`, '=', id)

or like this

function asUuid(val: string): RawBuilder<string> {
  return sql`${val}::uuid`
}

.where('id', '=', asUuid(id))