ugh, bit by missing [] a second time. Nevermind.
On Wednesday, March 19, 2014 8:46:37 PM UTC-7, Brian Craft wrote:
>
> honeysql supports function calls by joining args with commas, e.g.
>
> => (hsql/format #sql/call [:foo :bar :baz])
> ["foo(bar, baz)"]
>
>
> However sql functions have more syntax, for example group_concat(a order
> by b separator ',')
>
> So #sql/call doesn't work. I tried implementing a clause format for
> group_concat:
>
> => (hsql/format {:group_concat [:value {:order :ordering :separator
> #sql/call [:chr 9]}]})
> ["GROUP_CONCAT(value order by ordering separator chr(9))"]
>
> However this doesn't work inside a select:
>
> => (hsql/format {:select {:group_concat [:value {:order :ordering
> :separator #sql/call [:chr 9]}]} :from [:foo]})
> ["SELECT group_concat AS value AS ( ) FROM foo"]
>
> Is there any solution besides dropping to raw sql?
>
>
>
--
You received this message because you are subscribed to the Google
Groups "Clojure" group.
To post to this group, send email to clojure@googlegroups.com
Note that posts from new members are moderated - please be patient with your
first post.
To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
---
You received this message because you are subscribed to the Google Groups
"Clojure" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to clojure+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
