I have tried CROSS JOIN and CASE WHEN (why be greedy, right?):
WITH myself AS (
SELECT uid
FROM words_social
WHERE social = in_social
AND sid = in_sid
LIMIT 1
),
opponent AS (
SELECT CASE WHEN player1 = myself.uid THEN player2 ELSE player1 END
FROM words_games
WHERE gid = in_gid
)
SELECT
CASE WHEN c.uid = myself.uid THEN 1 ELSE 0 END,
c.msg
FROM myself CROSS JOIN opponent
WHERE (c.uid = myself.uid OR NOT opponent.muted)
ORDER BY c.CREATED ASC;
but the error is:
ERROR: missing FROM-clause entry for table "myself"
LINE 60: SELECT CASE WHEN player1 = myself.uid THEN play...
^
