On Wednesday, February 1, 2023, Ron <ronljohnsonjr@xxxxxxxxx> wrote:
https://www.postgresql.org/docs/12/sql-select.html
The docs say that one of these are required in the SELECT list.
[ * |_expression_
[ [ AS ]output_name
] [, ...] ]
The square brackets you show are how optional elements are introduced so while those two options exists neither are required.
David J.