DATE_TRUNC function in user_cumulated_populate.sql
Closed this issue · 1 comments
pavlokurochka commented
bootcamp/materials/2-fact-data-modeling/lecture-lab/user_cumulated_populate.sql
conflicts with
bootcamp/materials/1-dimensional-data-modeling/docker-compose.yml
that specifies
image: postgres:14
reason: DATE_TRUNC function is not available in 14. Current pg version is 17.
looks like DATE function delivers the same results as far as script concerned.
ry-v1 commented
DATE_TRUNC function is available in 14.