first_last_agg

This Release
first_last_agg 0.1.4
Date
Status
Stable
Latest Testing
first_last_agg 0.1.2 —
Other Releases
Abstract
Provides first() and last() aggregate functions.
Released By
wulczer
License
PostgreSQL
Resources
Special Files
Tags

README

Contents

first_last_agg

A simple extension providing two aggregate functions, last and first aggregate functions, operating on any element type and returning the last or the first value of the group.

Since by default the ordering inside groups created by a GROUP BY expression is not defined, it is advisable to use an ORDER BY clause inside the aggregate expression (see the aggregate function syntax). This feature has been added in PostgreSQL 9.0.

This extension is intended to replace the corresponding first and last aggregates from the PostgreSQL wiki.