test=# select from sales_detail;
--
(11 rows)
It returned 11 rows as per the psql output text, if it acted like count(*), an aggregate, it would have only returned one row.
You have produced an 11-row, 0-column, output table. It isn’t “supported” but is allowed for technical convenience, hence the decision to avoid trying to communicate this fact in the syntax diagram.
David J.
