From: "Jeremy Kronuz" <kronuz(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: ISBN/ISSN/ISMN/EAN13 module
Date: 2006-09-09 22:48:10
Message-ID: BAY107-F56D0554E38EF428D3F1E6D8340@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-patches

I also added other functionality to the module but I forgot to update the
README... contrary to what it says in the README.isn, you do can cast from
ean13 to other types, as long as the cast is valid (i.e. you can't cast a
EAN13 of a UPC or a ISMN code to a ISBN number, for instance.)

So, the text starting at line 184 in the README.isn should say something
like this instead:

-- note that you can only cast from ean13 to other type when the casted
-- number would be valid in the realm of the casted type;
-- thus, the following will NOT work: select isbn(ean13('0220356483481'));
-- but these will:
select upc(ean13('0220356483481'));
select ean13(upc('220356483481'));

(this is not in my patch, I just realized about this)

"Fools rush in where fools have been before" Unknown

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message MAR - Secretariado Geral 2006-09-09 22:55:58 Foreign keys
Previous Message Joshua D. Drake 2006-09-09 22:25:55 Re: Release notes

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-09-10 00:41:59 Re: ISBN/ISSN/ISMN/EAN13 module
Previous Message Jeremy Kronuz 2006-09-09 22:13:51 ISBN/ISSN/ISMN/EAN13 module