All pastes #362284 Raw Edit

Someone

public sql v1 · immutable
·published 2007-02-18 18:27 UTC
rendered paste body
SELECT news_url, news_date FROM newsWHEREdate_part('month', news_date) = date_part('month', CURRENT_DATE)group by news_datelimit 5ERROR:  column "news.news_url" must appear in the GROUP BY clause or be used in an aggregate functionoguaira=#