title: Favorite unit-testing approach for Postgresql functions?
body: <p>I'm used to developing Java applications, but for a project I do posgresql functions. I would like to write small unittests for these functions.</p>
  
  <p>I'm currently looking for a standard approach. I found pgTap and pgUnitTest, and an article from 2007: <a href="http://www.bigsmoke.us/postgresql-unit-testing/">http://www.bigsmoke.us/postgresql-unit-testing/</a></p>
  
  <p>What are you approaches to unit-testing postgresql functions? How do you mock data / separate testdata? How to isolate unit-tests? And which framework or approach is favored (I use jUnit and testNG for java)?</p>