Hi everyone I m pretty new to exposed and I m wondering if t kotlinlang #exposed

Hi everyone, I’m pretty new to exposed, and I’m wo...

Edouard Goossens

01/28/2019, 9:55 PM

Hi everyone, I’m pretty new to exposed, and I’m wondering if there’s a way to do something equivalent to:

SELECT field1, field2, field2-field1 AS diff FROM table

using DAO. Thanks!

tapac

01/29/2019, 10:19 AM

Copy code

val diff = val columns = Expression.build { Table.field2 - Table.field1 }.alias("diff")
Table.slice(Table.field1, Table.field2, diff).selectAll()

Edouard Goossens

01/29/2019, 10:49 AM

Thanks!