Not exactly sst related, but trying to use `RDS` c...
# helpn
Noah D
02/26/2022, 3:14 AMNot exactly sst related, but trying to use
RDSkyselyuserId Copy code
ERROR: operator does not exist: uuid == character varyingt
thdxr
02/26/2022, 3:14 AMinteresting, haven't tried this yet
n
Noah D
02/26/2022, 3:14 AMSeems pretty common to cast uuid as text in raw SQL https://stackoverflow.com/questions/46433459/postgres-select-where-the-where-is-uuid-or-string
t
thdxr
02/26/2022, 3:14 AMkysely has a discord - would suggest asking there
n
Noah D
02/26/2022, 3:14 AMBut unsure how to with kysely
t
thdxr
02/26/2022, 3:14 AMyou can use
Db.rawthdxr
02/26/2022, 3:15 AMhe probably would support uuid natively though
thdxr
02/26/2022, 3:15 AM Copy code
.where("times_verified", "is", Database.raw("null"))n
Noah D
02/26/2022, 3:16 AMThanks for the tips @thdxr, i'll shoot them a message and report back 👍
Noah D
02/26/2022, 7:02 AMFor future travellers, this is possible to achieve, you must cast the uuid as text first though and the uuid you are comparing against must be a valid uuid. To get mine working I can use something that looks like
Copy code
const item = await database.selectFrom('items')
.selectAll()
.where(sql`items.item_id::text`, '=', '0ca08fa2-46db-45d6-bb25-d35b8bbbc890')
.execute();Noah D
02/26/2022, 7:03 AMWhere you can replace the hard coded uuid there with whatever uuid you have etc