theory/pg-semver v0.40.0

Release v0.40.0

on GitHub

Changes for v0.40.0:

• Updated the installation configuration to install the SQL and
  documentation files into semver subdirectories.
• Changed the tests to use CREATE EXTENSION instead of loading the
  SQL source file directory. The latter was required for Postgres 9.0
  and lower, which have not been supported since v0.20.0 back in 2018.
• Fixed a bug that rejected pre-releases starting with a zero but
  eventually include a dash, e.g., 1.2.3-02-3. Thanks to Dylan
  Bourque for the pull request (#70)!
• ***** WARNING: This release breaks compatibility with previous versions! ******
  Fixed a bug in the scanning of pre-releases that start with a zero.
  It now properly scans the rest of the pre-release string. As a result,
  existing semvers with pre-releases the start with a zero may have been
  incorrectly interpreted as valid. Any versions returned by this query
  will need the leading 0 removed from the pre-release before upgrading:
  SELECT version FROM pkg WHERE get_semver_prerelease(version) ~ '^0\[0-9]+($|\+)'
  Discovered while debugging unexpected test failures in #70.