In postgresql – selecting maximum for each group, we saw the actual stored function.  That was the easy part.  Then there was dealing with Postgresql and JDBC.  I encountered a few surprises while doing this. Calling the stored function I expected to use JDBC’s CallableStatement since I was calling a stored procedure.  Nope.  The proper [...]

I had a requirement to return the thread with the most replies in each forum at JavaRanch‘s Coderanch forums.  In Postgresql 8.4, this would be very easy – just use the window functions.  Unfortunately, we aren’t on Postgresql 8.4 yet.  The other common pattern is something like This doesn’t work well for me either because [...]

We saw how to clone a postgresql database for testing cleanly in an earlier blog post. The next step is to do so from Java so it can be part of an integration test. How to run each of 4 DDLs: Running a DDL file is easy which is good since we have four of [...]