Alexander Shulgin <alex(dot)shulgin(at)gmail(dot)com> writes:
> I understand that there's really not much point in running COUNT w/o
> the FROM list, but maybe we should just disallow COUNT(*) with empty
> FROM list?
While I don't offhand see a use case for aggregates without FROM,
it's a long way from there to asserting that there is no use case.
The real foot-gun here IMO is the ability to omit "AS", which
unfortunately we're kind of stuck with because it's in the SQL standard.
regards, tom lane