> As the error indicates, you must give an alias for subquery > > select a,count(1) FROM (select a from X UNION select a from Y ) as > your_alias_name group by a; Ohh, I see. I completly misunderstood it earlier. Thanks for clearing that up :-)
pgsql-novice by date:
Соглашаюсь с условиями обработки персональных данных