postgresql/contrib/isbn_issn
Tom Lane ec8576114f Some more gitignore cleanups: cover contrib and PL regression test outputs.
Also do some further work in the back branches, where quite a bit wasn't
covered by Magnus' original back-patch.
2010-09-22 17:22:31 -04:00
..
.gitignore Some more gitignore cleanups: cover contrib and PL regression test outputs. 2010-09-22 17:22:31 -04:00
Makefile To fix the perpetually broken makefiles in the contrib tree, I have 2001-09-06 10:49:30 +00:00
README.isbn_issn Add missing /contrib files 2000-06-19 14:02:16 +00:00
isbn_issn.c Error message editing in contrib (mostly by Joe Conway --- thanks Joe!) 2003-07-24 17:52:50 +00:00
isbn_issn.sql.in Make sure contrib C functions are marked strict where needed. 2005-01-29 22:35:30 +00:00

README.isbn_issn

ISBN (books) and ISSN (serials)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

This directory contains definitions for a couple of PostgreSQL
external types, for a couple of international-standard namespaces:
ISBN (books) and ISSN (serials).  Rather than just using a char()
member of the appropriate length, I wanted my database to include
the validity-checking that both these numbering systems were designed
to encompass.  A little bit of research revealed the formulae
for computing the check digits, and I also included some validity
constraints on the number of hyphens.

The internal representation of these types is intended to be
compatible with `char16', in the (perhaps vain) hope that
this will make it possible to create indices of these types
using char16_ops.

These are based on Tom Ivar Helbekkmo's IP address type definition,
from which I have copied the entire form of the implementation.

Garrett A. Wollman, August 1998