search

korma / Korma

Tasty SQL for Clojure.
http://sqlkorma.com
1.48k stars 222 forks source link

Calling a postgres procedure #272

Closed Andati closed 9 years ago

Andati commented 9 years ago

How do I call a postgres proc?

I am currently using row sql. And it fails when I add :results saying there are no results. When I remove the :results, it says results were returned.

immoh commented 9 years ago

Could you post a minimal failing case (stored proc) + exec-raw call? Thanks.

Andati commented 9 years ago

I found the issue was: I was executing two separate sql statements in one exec-raw call. I was first setting date-style and then calling the proc. I removed the date-style call and it worked ok.