Can Clojure Korma produce WITH - RETURNING query in Postgres?

Question

I'm trying to reproduce this query from the Postgres docs:

WITH moved_rows AS (
    DELETE FROM products
    WHERE
        "date" >= '2010-10-01' AND
        "date" < '2010-11-01'
    RETURNING *
)
INSERT INTO products_log
SELECT * FROM moved_rows;

Can Korma actually do it (besides just writing raw SQL, of course)? I see no mention of it in the docs.

Thanks...

Aleksei Zyrianov · Accepted Answer · 2014-07-23 21:20:34Z

1

After diving into Korma source code, I've noticed that it generates queries by itself. Then I've grepped through the Korma source code and it has no RETURNING keyword in it:

$ grep -ri returning .
$

So I came to a conclusion that unfortunately currently Korma doesn't support WITH-RETURNING Postgres' syntax.

What you could do next is to contact Korma developers in their mailing list.

answered Jul 23, 2014 at 21:20

Aleksei Zyrianov

2,3821 gold badge25 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

boechat107 · Accepted Answer · 2014-12-05 12:09:56Z

0

I have successfully executed a similar query, an UPDATE with the RETURNING keyword, using the exec-raw function.

answered Dec 5, 2014 at 12:09

boechat107

1,72215 silver badges24 bronze badges

Collectives™ on Stack Overflow

Can Clojure Korma produce WITH - RETURNING query in Postgres?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related