SELECT table_type FROM table;

By accident, a colleague came across something unexpected. Here is a
simple example:

create table testo(gonk integer,spoodle text);
CREATE TABLE
agentm=# insert into testo values(1,'hello');
INSERT 0 1
agentm=# insert into testo values(2,'text');
INSERT 0 1
agentm=# select testo from testo;
   testo
-----------
 (1,hello)
 (2,text)
(2 rows)

Obviously, this is intentional behavior but where is it documented? I am
aware that testo is also a type and that a set is returned for each row
but this must be a special case, no? Alternate types don't seem to apply.

agentm=# create type nice as (gonk integer,spoodle text);
CREATE TYPE
agentm=# select nice from testo;
ERROR:  column "nice" does not exist
agentm=# select *::nice from testo;
ERROR:  syntax error at or near "::" at character 9
LINE 1: select *::nice from testo;
                ^
agentm=# select cast(* as nice) from testo;
ERROR:  syntax error at or near "*" at character 13
LINE 1: select cast(* as nice) from testo;
                    ^
Also, how can I turn each set row into an array?

-M