Ah, thanks - I've got that with JOINing via CASE now...
On Mon, Oct 31, 2016 at 5:50 PM, Geoff Winkless <pgsqladmin@geoff.dj> wrote:
especially since (as I said in the last paragraph of my email), you can remove all of the CASEs except the hand/score ones by just JOINing the other tables via a CASE anyway.