Package: postgresql-12-first-last-agg Source: first-last-agg Version: 0.1.4-4-gd63ea3b-7.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 51 Depends: postgresql-12, postgresql-12-jit-llvm (>= 14) Homepage: https://github.com/wulczer/first_last_agg Priority: optional Section: database Filename: pool/main/f/first-last-agg/postgresql-12-first-last-agg_0.1.4-4-gd63ea3b-7.pgdg22.04+1_amd64.deb Size: 8392 SHA256: 1b1ba9dfd1d0d06a906c44cb546de76c4b06255a3a0366bb699736743dca2cb3 SHA1: f9373e7c2740d26711cf7c82f116d3cd48f4f0a1 MD5sum: c828638c2d6bd1a6f2816daedaead2b9 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).