Timeline for Postgres show count 0 for non-matching rows for 1 table
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 20, 2020 at 21:13 | vote | accept | 425nesp | ||
| Mar 20, 2020 at 14:37 | comment | added | Akina | @jjanes Maybe. But I do not prefer postgres, so always forget about the constructions specific for it. | |
| Mar 20, 2020 at 14:16 | comment | added | jjanes |
I think it would be simpler to replace the recursive CTE with something like generate_series(date_trunc('day',now()-interval '5 days'),now(), interval '1 day')
|
|
| Mar 20, 2020 at 5:21 | history | answered | Akina | CC BY-SA 4.0 |