Le 17/10/2021 à 23:48, Isaac Morland a écrit : > On Sun, 17 Oct 2021 at 17:42, Gilles Darold <gil...@migops.com > <mailto:gil...@migops.com>> wrote: > > Perhaps I misunderstand what you are saying, but a no-columns table > definitely can return rows: > > psql (12.2) > Type "help" for help. > > postgres=# create table nada (); > CREATE TABLE > postgres=# insert into nada default values; > INSERT 0 1 > postgres=# insert into nada default values; > INSERT 0 1 > postgres=# table nada; > -- > (2 rows) > > postgres=# > > Note that psql doesn't display a separate line for each row in this > case, but the actual result coming back from the server does contain > the appropriate number of rows.
I was not aware of that. In this case perhaps that we can remove the restriction on having at least on expandable column and we will have the same behavior but I can't think of an interest to allow that. -- Gilles Darold