Package: postgresql-9.6-first-last-agg Source: first-last-agg Version: 0.1.4-4-gd63ea3b-5.pgdg18.04+1 Architecture: i386 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 34 Depends: postgresql-9.6 Homepage: https://github.com/wulczer/first_last_agg Priority: optional Section: database Filename: pool/main/f/first-last-agg/postgresql-9.6-first-last-agg_0.1.4-4-gd63ea3b-5.pgdg18.04+1_i386.deb Size: 5712 SHA256: f2f7d5ea062d9d04851d19276fd55b600737cab0e2826d2894e2def8047a1173 SHA1: 2059054f0383cdb73bec3f509a8f4a6dcc387aee MD5sum: 2b3b57fcbef1fcb2f3602ad41366a02f Description: PostgreSQL extension providing first and last aggregate functions first-last-agg is a simple extension providing two aggregate functions, last and first, 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).