by

Window Functions: PostgreSQL’s Best-Kept Secret

Analysis
Nov 18, 20111 min

The PostgreSQL relational database management system (RDBMS) extends the standard SQL3 it implements with several conveniences for application development. Among the most useful extensions are window functions, which perform a calculation across a set of table rows that are somehow related to the current row.

Open Source
by

More from this author

Show me more

news

Arista hits first $3B quarter as AI networking momentum continues

By Michael Cooney
7 mins
Enterprise RoutersNetwork SwitchesNetworking Devices
Image
news analysis

AI erased the 50-day patch window. Palo Alto Networks has a response

By Zeus Kerravala
6 mins
Network SecuritySecurity SoftwareThreat and Vulnerability Management
Image
news

2026 network outage report and internet health check

By Ann Bednarz
78 mins
Cloud ComputingNetwork Management SoftwareNetwork Monitoring
Image
podcast

Has the hype around ‘Internet of Things’ paid off? | Ep. 145

36 mins
IoT PlatformsIoT Security
Image
podcast

Episode 1: Understanding Cisco’s Converged SDN Transport

20 mins
Cisco SystemsInternetNetworking
Image
podcast

Episode 2: Pluggable Optics and the Internet for the Future

17 mins
Cisco SystemsComputers and PeripheralsInternet
Image
video

Master Linux Math with the bc Command | Easy CLI Calculations Explained!

1 mins
Operating Systems
Image
video

Master Linux Math in Seconds: How to Use the expr Command Like a Pro

1 mins
Operating Systems
Image
video

How to Do Math in the Command Line Using Double Parentheses

1 mins
Operating Systems
Image