Package: postgresql-10-first-last-agg Source: first-last-agg Version: 0.1.4-4-gd63ea3b-8.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 42 Depends: postgresql-10 Homepage: https://github.com/wulczer/first_last_agg Priority: optional Section: database Filename: pool/main/f/first-last-agg/postgresql-10-first-last-agg_0.1.4-4-gd63ea3b-8.pgdg22.04+1_amd64.deb Size: 5760 SHA256: 1bc992758e28a190163da08c76f8fb8231fd4faae4008d3870c6aca6c3d8cc39 SHA1: 6ee4fd66e780cbd0a0c8ad3f13b23dcb6e7e6f19 MD5sum: 6b1ad333df930dbfdaf5c89e5ce3b6ec 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).