2009/4/11 Grzegorz Jaskiewicz <g...@pointblue.com.pl>: > > On 11 Apr 2009, at 08:01, Hitoshi Harada wrote: > >> 2009/4/11 David Fetter <da...@fetter.org>: >>> >>> On Sat, Apr 11, 2009 at 03:48:33PM +0900, Hitoshi Harada wrote: >>>> >>>> Yeah, but all the window functions are stored in pg_proc. >>> >>> So are aggregate functions, and they have their own separate way of >>> being addressed in psql :) >>> >> >> Aggregate functions are stored in pg_aggregate. And they are >> combinations of plain function which is stored in pg_proc. > > > Maybe trigger functions should be displayed separately too than ?
You don't catch the point. The aggregate entries in pg_proc have prosrc = 'aggregate_dummy', which means they're dummy and the entities are stored in pg_aggregate. Triggers in pg_proc are dummy? No, they are actually plain functions with trigger return type. Regards, -- Hitoshi Harada -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers