GTIN14 support for contrib/isn
Michael Kefeder <mike@multiwave.ch>
From: Michael Kefeder <mike@multiwave.ch>
To: pgsql-hackers@lists.postgresql.org
Date: 2019-03-15T16:01:49Z
Lists: pgsql-hackers
Attachments
- gtin14.patch (text/plain) patch
Hello hackers, For a project of ours we need GTIN14 data type support. The isn extension already supports EAN13, and a '0' prefixed EAN13 is a valid GTIN14. The leftmost "new" 14th digit is a packaging level indicator which we need (= using EAN13 and faking a leading 0 in output doesn't cut it). Looking at the code I saw every format that isn-extension supports is stored as an EAN13. Theoretically that can be changed to be GTIN14, but that would mean quite a lot of rewrite I feared, so I chose to code only GTIN14 I/O separetely to not interfere with any existing conversion magic. This yields an easier to understand patch and doesn't touch existing functionality. However it introduces redundancy to a certain extent. Find my patch attached. Please let me know if there are things that need changes, I'll do my best to get GTIN support into postgresql. thanks in advance mike
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Add a 64-bit hash function for type hstore.
- eb6f29141bed 12.0 cited