Comment 0 for bug 1564402

Revision history for this message
Jason Stephenson (jstephenson) wrote :

As mentioned in IRC yesterday (http://irc.evergreen-ils.org/evergreen/2016-03-30#i_239409), I have a use case for a database function to return the ISBN13 from its input in the database.

My use case involves dumping data for Novelist's On The Shelf product where they specifically ask for the unique combination of ISBN13 and copy barcode. Pulling the ISBN13 in the database allows use to distinct on the field and to skip records where the data in the ISBN is invalid or cannot be converted to ISBN13.

A branch to create the evergreen.isbn13(text) function will be forthcoming.