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 |
Thread: | |
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)
Kronuz.
"Fools rush in where fools have been before" Unknown
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 |
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 |