Search Postgresql Archives

Re: RE : Re: database design ...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Desmond Coughlan wrote:
X-No-Archive: true
Just had a thought. If you see .. http://www.chez.com/desmondcoughlan/unix/cdi_gt.sql

With the ISBN number you may want to look at contrib/isn - this adds ISBN types. If not then varchar(12) won't hold the new ISBN-13 format that is in full effect next year.


From the readme -

This directory contains definitions for a few PostgreSQL
data types, for the following international-standard namespaces:
EAN13, UPC, ISBN (books), ISMN (music), and ISSN (serials). This module
is inspired by Garrett A. Wollman's isbn_issn code.

I wanted the database to fully validate numbers and also to use the
upcoming ISBN-13 and the EAN13 standards, as well as to have it
automatically doing hyphenations for ISBN numbers.

This new module validates, and automatically adds the correct
hyphenations to the numbers. Also, it supports the new ISBN-13
numbers to be used starting in January 2007.



--

Shane Ambler
pgSQL@xxxxxxxxxxxxxxxx

Get Sheeky @ http://Sheeky.Biz


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux