Auxiliary window functions

[monetdb-team]

Date: 2013-10-13 13:57:25 +0200
From: @mlkersten
To: SQL devs <>
Version: -- development

Last updated: 2019-04-30 12:36:00 +0200

Comment 19272

Date: 2013-10-13 13:57:25 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:24.0) Gecko/20100101 Firefox/24.0
Build Identifier:

The following Postgresql window functions are not yet provided.

percent_rank() double precision relative rank of the current row: (rank - 1) / (total rows - 1)

cume_dist() double precision relative rank of the current row: (number of rows preceding or peer with current row) / (total rows)

ntile(num_buckets integer) integer integer ranging from 1 to the argument value, dividing the partition as equally as possible

lag(value any [, offset integer [, default any ]]) same type as value returns value evaluated at the row that is offset rows before the current row within the partition; if there is no such row, instead return default. Both offset and default are evaluated with respect to the current row. If omitted, offset defaults to 1 and default to null

lead(value any [, offset integer [, default any ]]) same type as value returns value evaluated at the row that is offset rows after the current row within the partition; if there is no such row, instead return default. Both offset and default are evaluated with respect to the current row. If omitted, offset defaults to 1 and default to null

first_value(value any) same type as value returns value evaluated at the row that is the first row of the window frame

last_value(value any) same type as value returns value evaluated at the row that is the last row of the window frame

nth_value(value any, nth integer) same type as value returns value evaluated at the row that is the nth row of the window frame (counting from 1); null if no such row

Reproducible: Always

Comment 26827

Date: 2019-01-21 17:14:53 +0100
From: @sjoerdmullender

Will be in next feature release.