Operations on aggregations

[Antonio A. Carrillo]

Hello.

I can't find how to translate the following SQL into Korma:

SELECT SUM(quantity*direction) FROM movements;

I don't know how to represent an operation into aggregation columns using Korma.

Thanks.

[Immo Heikkinen]

Unfortunately there's no built-in support for operations. You can use `raw` to represent an operation:

(sql-only (select :movements (fields (sqlfn sum (raw "\"quantity\"*\"direction\"")))))

=> "SELECT SUM(\"quantity\"*\"direction\") FROM \"movements\""

or use `exec-raw` to execute any SQL.

--
You received this message because you are subscribed to the Google Groups "Korma" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sqlkorma+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.