From: | Joel Barnard <joel(at)joelbarnard(dot)ca> |
---|---|
To: | "pgsql-www(at)postgresql(dot)org" <pgsql-www(at)postgresql(dot)org> |
Subject: | I would like editor access to the wiki... |
Date: | 2021-05-07 20:47:36 |
Message-ID: | DM5PR14MB13086C45E9774E8F010B8492BE579@DM5PR14MB1308.namprd14.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-www |
I would like editor access to the wiki, my username is jebarnard and I would like to modify:
https://wiki.postgresql.org/wiki/Luhn_algorithm
The math is incorrect for the luhn_generate_checkdigit function, it returns invalid values for 1, 10, 100, 1000 ....
FROM generate_series(0, ceil(log($1))::integer - 1) AS n
should be changed to:
FROM generate_series(0, floor(log($1))::integer) AS n
Thanks,
Joel Barnard
Luhn algorithm - PostgreSQL wiki<https://wiki.postgresql.org/wiki/Luhn_algorithm>
Luhn algorithm implementation by Craig Ringer in pure SQL (PostgreSQL function dialect, but should be easily adapted to other DBMSs). Note that this implementation is ...
wiki.postgresql.org
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2021-05-08 20:33:32 | Re: I would like editor access to the wiki... |
Previous Message | Jonathan S. Katz | 2021-05-07 16:38:06 | Re: Up-level link on mailing lists archives pages |