PostgreSQL 11.22 DocumentationAuthentication ........................................................................... 620 20.9. Peer Authentication ............................................................................ 620 20 row's first peer row (a row that the window's ORDER BY clause sorts as equivalent to the current row), while a frame_end of CURRENT ROW means the frame ends with the current row's last peer row. In ROWS option means that the frame starts or ends the specified number of peer groups before or after the current row's peer group, where a peer group is a set of rows that are equivalent in the ORDER BY ordering0 码力 | 2732 页 | 12.44 MB | 1 年前3
PostgreSQL 14.10 DocumentationAuthentication ................................................................................. 705 21.9. Peer Authentication .................................................................................. row's first peer row (a row that the window's ORDER BY clause sorts as equivalent to the current row), while a frame_end of CURRENT ROW means the frame ends with the current row's last peer row. In ROWS option means that the frame starts or ends the specified number of peer groups before or after the current row's peer group, where a peer group is a set of rows that are equivalent in the ORDER BY ordering0 码力 | 3032 页 | 13.27 MB | 1 年前3
PostgreSQL 14.10 DocumentationAuthentication ........................................................................... 672 21.9. Peer Authentication ............................................................................ 673 21 row's first peer row (a row that the window's ORDER BY clause sorts as equivalent to the current row), while a frame_end of CURRENT ROW means the frame ends with the current row's last peer row. In ROWS option means that the frame starts or ends the specified number of peer groups before or after the current row's peer group, where a peer group is a set of rows that are equivalent in the ORDER BY ordering0 码力 | 2871 页 | 13.38 MB | 1 年前3
PostgreSQL 13.13 DocumentationAuthentication ........................................................................... 650 20.9. Peer Authentication ............................................................................ 650 20 row's first peer row (a row that the window's ORDER BY clause sorts as equivalent to the current row), while a frame_end of CURRENT ROW means the frame ends with the current row's last peer row. In ROWS option means that the frame starts or ends the specified number of peer groups before or after the current row's peer group, where a peer group is a set of rows that are equivalent in the ORDER BY ordering0 码力 | 2782 页 | 13.00 MB | 1 年前3
PostgreSQL 11.22 DocumentationAuthentication ................................................................................. 652 20.9. Peer Authentication .................................................................................. row's first peer row (a row that the window's ORDER BY clause sorts as equivalent to the current row), while a frame_end of CURRENT ROW means the frame ends with the current row's last peer row. In ROWS option means that the frame starts or ends the specified number of peer groups before or after the current row's peer group, where a peer group is a set of rows that are equivalent in the ORDER BY ordering0 码力 | 2883 页 | 12.34 MB | 1 年前3
PostgreSQL 13.14 DocumentationAuthentication ................................................................................. 686 20.9. Peer Authentication .................................................................................. row's first peer row (a row that the window's ORDER BY clause sorts as equivalent to the current row), while a frame_end of CURRENT ROW means the frame ends with the current row's last peer row. In ROWS option means that the frame starts or ends the specified number of peer groups before or after the current row's peer group, where a peer group is a set of rows that are equivalent in the ORDER BY ordering0 码力 | 2940 页 | 12.89 MB | 1 年前3
PostgreSQL 12.17 DocumentationAuthentication ........................................................................... 648 20.9. Peer Authentication ............................................................................ 648 20 row's first peer row (a row that the window's ORDER BY clause sorts as equivalent to the current row), while a frame_end of CURRENT ROW means the frame ends with the current row's last peer row. In ROWS option means that the frame starts or ends the specified number of peer groups before or after the current row's peer group, where a peer group is a set of rows that are equivalent in the ORDER BY ordering0 码力 | 2786 页 | 12.72 MB | 1 年前3
PostgreSQL 12.17 DocumentationAuthentication ................................................................................. 682 20.9. Peer Authentication .................................................................................. row's first peer row (a row that the window's ORDER BY clause sorts as equivalent to the current row), while a frame_end of CURRENT ROW means the frame ends with the current row's last peer row. In ROWS option means that the frame starts or ends the specified number of peer groups before or after the current row's peer group, where a peer group is a set of rows that are equivalent in the ORDER BY ordering0 码力 | 2943 页 | 12.61 MB | 1 年前3
PostgreSQL 9.1.24 Documentation
Authentication.................................................................................472 19.3.7. Peer Authentication..................................................................................473 CURRENT ROW; it sets the frame to be all rows from the partition start up through the current row’s last peer in the ORDER BY ordering (which means all rows if there is no ORDER BY). In general, UNBOUNDED PRECEDING row; but in RANGE mode it means that the frame starts or ends with the current row’s first or last peer in the ORDER BY ordering. The value PRECEDING and value FOLLOWING cases are currently only allowed0 码力 | 2667 页 | 6.57 MB | 1 年前3
PostgreSQL 9.1 Documentation......................................................................................502 19.3.7. Peer Authentication................................................................................... ROW; it sets the frame to be all rows from the parti- tion start up through the current row’s last peer in the ORDER BY ordering (which means all rows if there is no ORDER BY). In general, UNBOUNDED PRECEDING row; but in RANGE mode it means that the frame starts or ends with the current row’s first or last peer in the ORDER BY ordering. The value PRECEDING and value FOLLOWING cases are currently only allowed0 码力 | 2836 页 | 6.62 MB | 1 年前3
共 36 条
- 1
- 2
- 3
- 4













