Hacker News Reader

Comment by joevandyk | Hacker News Reader

You gotta be careful when using BETWEEN.

BETWEEN does

    a >= x AND a <= y

Usually, you want

    a >= x AND a < y

http://www.postgresql.org/docs/9.3/static/functions-comparis...

View on HN

This is why I love the Postgres range types so much (http://www.postgresql.org/docs/9.4/static/rangetypes.html). With those, you get to chose based on the value whether your ranges include the boundaries or not. Even better: you get to chose for both start and end.

I recently replaced all my a >= x AND a < y with BETWEEN, and then I realised I got burned by what you describe :-) It's been on the Trello to-do to fix it for weeks...

Good point!

Edit: my parent post is wrong, the guide is using <, not <=, but I can't edit it now.

Reply on news.ycombinator.com