Kysely•3y ago

How to write "SELECT 1 FROM tablename"

I want to create subquery for exists but don't know type select(1)...? should I use val or sql.lit or other way...? Thanks in advance

https://kyse.link/?p=s&i=rF7gNapHXGQFdbmhVHJx

koskimas•8/4/23, 12:40 PM

You can use or

lit

lit

but you have to give the selection an alias even though it's usesless in this case. Otherwise kysely don't know what to add to the output type https://kyse.link/?p=s&i=9vWXxaSZTy5Qc6v8pSNU

koskimas•8/4/23, 12:41 PM

You get the same performance if you select a column like

id

id

though. is an optimization from the 80s before good query optimizers

mikeOP•8/4/23, 12:49 PM

fair enough. I've done it already with column name and it works as expected. thanks