Johann Spies wrote: > SELECT A.article_id, A publication_year You are missing a "." between in what you think is the second column (after the "A").
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных