Fork me on GitHub
#sql
<
2020-06-08
>
seancorfield19:06:07

@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?).

grzm13:06:37

@U04V70XH6 Definitely interested in talking. Would you be open to a call or zoom session or an email thread?

seancorfield16:06:42

Thanks. Yeah, email would probably be best since I can share code etc. I'm <mailto:[email protected]|[email protected]> 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.

seancorfield19:06:05

(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)