Fix output of ISBN-13 numbers beginning with 979.

Enterprise / PostgreSQL - Heikki Linnakangas [iki.fi] - 2 August 2015 14:12 UTC

An EAN beginning with 979 (but not 9790 - those are ISMN's) are accepted as ISBN numbers, but they cannot be represented in the old, 10-digit ISBN format. They must be output in the new 13-digit ISBN-13 format. We printed out an incorrect value for those.

Also add a regression test, to test this and some other basic functionality of the module.

Patch by Fabien Coelho. This fixes bug #13442, reported by B.Z. Backpatch to 9.1, where we started to recognize ISBN-13 numbers.

cb3384a Fix output of ISBN-13 numbers beginning with 979.
contrib/isn/Makefile | 2 +
contrib/isn/expected/isn.out | 222 ++++++++++++++++++++++++++++++++++++++++++
contrib/isn/isn.c | 27 +++--
contrib/isn/sql/isn.sql | 104 ++++++++++++++++++++
4 files changed, 345 insertions(+), 10 deletions(-)

Upstream: git.postgresql.org


  • Share