Re: TODO items for window functions

Heikki Linnakangas escribió:
> Tom Lane wrote:
>> I am not thrilled about inventing a new column for this, but how about
>> a display like so:
>>
>> regression=# \df nth_value
>>                         List of functions
>>    Schema   |   Name    | Result data type |       Argument data types  
>> ------------+-----------+------------------+---------------------------------
>>  pg_catalog | nth_value | anyelement       | anyelement, integer OVER window
>>
>> or some other addition that only shows up when needed.
>
> That looks like "OVER window" is associated with the "integer", like  
> DEFAULT. I don't have any better suggestions, though.
                        List of functions   Schema   |   Name    | Result data type |        Argument data
types------------+-----------+------------------+-----------------------------------pg_catalog | nth_value | anyelement
     | (anyelement, integer) OVER window
 


-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support