16 votes

Don't Do This - PostgreSQL Wiki

2 comments

  1. [2]
    Adys
    Link
    I absolutely love the "Why not?" / "When should you?" format of this article, rather than just a dumb list of "here's things you shouldn't do, just trust me".

    I absolutely love the "Why not?" / "When should you?" format of this article, rather than just a dumb list of "here's things you shouldn't do, just trust me".

    10 votes
    1. unknown user
      Link Parent
      Exactly. Not sure why BETWEEN is on the list though. Are there really that many people who use an operator without checking the documentation for the precise meaning first? I've been using BETWEEN...

      Exactly. Not sure why BETWEEN is on the list though. Are there really that many people who use an operator without checking the documentation for the precise meaning first? I've been using BETWEEN in many queries where I needed an inclusive range and never had any issues.