Re: TODO items for window functions

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: TODO items for window functions
Дата
Msg-id 20081231120211.GB3809@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: TODO items for window functions  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: TODO items for window functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_pltemplate entries for external PLs
Следующее
От: "Stephen R. van den Berg"
Дата:
Сообщение: Lockfree hashtables