Categories / postgresql
SELECT DISTINCT ON (user_id, activity_type_id, EXTRACT(year FROM start_date_local))
Understanding Geotagged Location Data and Grouping Similar Entries: A Practical Approach to Counting Arrivals Over Time
Optimizing PostgreSQL Update Statements for Large Datasets and Missing Values