2009/4/11 Grzegorz Jaskiewicz <gj@pointblue.com.pl>:
>
> On 11 Apr 2009, at 08:01, Hitoshi Harada wrote:
>
>> 2009/4/11 David Fetter <david@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