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
