On Wednesday, February 1, 2023, Ron <ronljohnso...@gmail.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.