Clojurians Log v2
Clojure programming
Channels
Apps
honeysql 2024-02-07
Jo Øivind Gjernes 2024-02-07T15:00:14.881789Z
I’m trying to write a query like:
(select * from table_1 limit 10 order by x) union all (select * from table_1b limit 10 order by x) limit 10 order by x
p-himik 2024-02-07T15:25:53.014119Z
(sql/format {:union-all [{:nest {:select :*}}
{:nest {:select :*}}]
:limit [:inline 10]})
=> ["(SELECT *) UNION ALL (SELECT *) LIMIT 10"]p-himik 2024-02-07T15:27:59.969769Z
Yeah, I tried that at first too. :)
seancorfield 2024-02-07T18:03:31.255949Z
Happy to update the docs to make that easier to figure out, if you have suggestions. The :union-all docs mention :nest https://cljdoc.org/d/com.github.seancorfield/honeysql/2.5.1103/doc/getting-started/sql-clause-reference#intersect-union-union-all-except-except-all (but don't provide an example).
