I have a PostgreSQL (version 12.15) database with a table like this: id created_at number chat_id ... 2023-08-10 21:44:19.272299 0 27936 ... 2023-08-09 10:32:28.850167 0 27936 ... 2023-08-08 17:32:11.207523 0 27936 ... 2023-08-07 17:16:52.068309 0 27936 ... 2023-08-06 17:15:47.014364 0…
Example table with one column tmp_year_test.year and values: year 2010 2011 2012 And now the logic -- 2010 - OK select max(year) over () as max_year from tmp_year_test where year = 2010 -- let's put it in the view create…
For example, I have this table that contains two specific brands - 'Ford' and 'Subaru', which just so happen to be the top earning brands for the Eastern and Western markets respectively. To obtain this info, I make a view:…
I have a ledger-like table in a postgresql DB that tracks events for film comparisons on a site where users can add/remove film comparisons. Each event is recorded as a timestamped row in the event database. Rows are never removed:…