On Wednesday, February 1, 2023, Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
>
> 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.