last-agg v1.0.0

unique-agg

last non null data agreggate function for postgres

language: also available in:

Case of use

You want to repeat the value of some field if the next row has a null.

select id, last_agg(country) over (order by id), city
   from cities
   order by id;

Install

psql < bin/create_last_agg.sql

License

MIT