Miscellany

SELECT news_url, news_date FROM news
WHERE
date_part('month', news_date) = date_part('month', CURRENT_DATE)
group by news_date
limit 5


ERROR:  column "news.news_url" must appear in the GROUP BY clause or be used in an aggregate function
oguaira=#