On 31 October 2016 at 15:46, Alexander Farber <alexander.farber@xxxxxxxxx> wrote: > do you mean, instead of having player1, player2 columns in the words_games > table (as in my current schema > https://gist.github.com/afarber/c40b9fc5447335db7d24 ) - I should move the > player stuff (uid, hand, score) to a separate table and then JOIN them? I do - it's something that my databases lecturer would almost certainly have insisted upon, although I'm not sure it's worth it, 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. Geoff -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
