Update 00041875-fachoursbymonth2.ex to use EXTRACT

AlisdairO / pgexercises

PostgreSQL Exercises web site code

Other

400 stars 62 forks source link

Update 00041875-fachoursbymonth2.ex to use EXTRACT #39

Closed mritterhoff closed 3 years ago

mritterhoff commented 6 years ago

I think EXRACT should be used in the WHERE clause, instead of inequalities, since it's newly introduced in this exercise and leads to a more succinct query.

AlisdairO commented 3 years ago

My apologies for the criminally late response on this PR. My life got absurdly busy, and I'm just now looking over PRs.

I'll accept this PR shortly. I do think it introduces an opportunity to talk about the potential costs around indexing etc, so this is a nice one. Once I've got an explanation ready I'll merge your PR in.

AlisdairO commented 3 years ago

Done, followed up with 6445b64c75921aaee935bbef08ec4aa2c467cec4