Using (SELECT uid FROM myself) provides the same result without the from/join reference; the usage in the case and the where clause could be rewritten to use opponent.uid so myself.uid only appears once.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных