Re: Command Triggers, v16

Christian Ullrich <chris@chrullrich.net>

From: Christian Ullrich <chris@chrullrich.net>
To: pgsql-hackers@postgresql.org
Date: 2012-03-16T08:30:33Z
Lists: pgsql-hackers
* Thom Brown wrote:

> I don’t understand how functions can return a type of “command
> trigger”.  This certainly works, but I’ve never seen a type consisting
> of more than one word.  Could you explain this for me?  This is also

postgres=> with types (name) as
postgres-> (select format_type(oid, NULL) from pg_type)
postgres-> select name from types where name like '% %'
postgres-> and not name like '%[]';
             name
-----------------------------
  double precision
  character varying
  time without time zone
  timestamp without time zone
  timestamp with time zone
  time with time zone
  bit varying
(7 Zeilen)

I think these are all specially handled in the parser.

-- 
Christian Ullrich