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