Clojurians Log v2
Clojure programming
Channels
Apps
sql
All things SQL and JDBC...
seancorfield 2020-06-08T19:09:07.237700Z
@grzm Whenever you're around and have some free time, I'd like to pick your brains about PostgreSQL stored procedures (I think you're the right person to ask?).
grzm 2020-06-09T13:53:37.238900Z
@seancorfield Definitely interested in talking. Would you be open to a call or zoom session or an email thread?
seancorfield 2020-06-09T16:53:42.239100Z
Thanks. Yeah, email would probably be best since I can share code etc. I'm <mailto:sean@corfield.org|sean@corfield.org> and this is my starting point for stored procs https://github.com/seancorfield/next-jdbc/blob/multi-rs/test/next/jdbc/test_fixtures.clj#L152-L180 -- PG accepts that but doesn't even give me a single ResultSet back, just an update count of zero.
seancorfield 2020-06-08T19:10:05.238800Z
(and if anyone else here works with stored procedures regularly, I'd be interested in your feedback too -- since I'm working on supporting multiple result sets in next.jdbc and I want to know what people's expectations would be around such a feature)