Implemented ForeignScan node which executes a scan on a foreign table.
[pgsql-fdw.git] / contrib / isn / EAN13.h
blob571396bec5db350d318617172495043745a88304
1 /*
2 * EAN13.h
3 * PostgreSQL type definitions for ISNs (ISBN, ISMN, ISSN, EAN13, UPC)
5 * Information recompiled by Kronuz on August 23, 2006
6 * http://www.gs1.org/productssolutions/idkeys/support/prefix_list.html
8 * IDENTIFICATION
9 * $PostgreSQL$
13 /* where the digit set begins, and how many of them are in the table */
14 const unsigned EAN13_index[10][2] = {
15 {0, 6},
16 {6, 1},
17 {7, 1},
18 {8, 5},
19 {13, 20},
20 {33, 15},
21 {48, 19},
22 {67, 23},
23 {90, 17},
24 {107, 12},
26 const char *EAN13_range[][2] = {
27 {"000", "019"}, /* GS1 US */
28 {"020", "029"}, /* Restricted distribution (MO defined) */
29 {"030", "039"}, /* GS1 US */
30 {"040", "049"}, /* Restricted distribution (MO defined) */
31 {"050", "059"}, /* Coupons */
32 {"060", "099"}, /* GS1 US */
33 {"100", "139"}, /* GS1 US */
34 {"200", "299"}, /* Restricted distribution (MO defined) */
35 {"300", "379"}, /* GS1 France */
36 {"380", "380"}, /* GS1 Bulgaria */
37 {"383", "383"}, /* GS1 Slovenija */
38 {"385", "385"}, /* GS1 Croatia */
39 {"387", "387"}, /* GS1 BIH (Bosnia-Herzegovina) */
40 {"400", "440"}, /* GS1 Germany */
41 {"450", "459"}, /* GS1 Japan */
42 {"460", "469"}, /* GS1 Russia */
43 {"470", "470"}, /* GS1 Kyrgyzstan */
44 {"471", "471"}, /* GS1 Taiwan */
45 {"474", "474"}, /* GS1 Estonia */
46 {"475", "475"}, /* GS1 Latvia */
47 {"476", "476"}, /* GS1 Azerbaijan */
48 {"477", "477"}, /* GS1 Lithuania */
49 {"478", "478"}, /* GS1 Uzbekistan */
50 {"479", "479"}, /* GS1 Sri Lanka */
51 {"480", "480"}, /* GS1 Philippines */
52 {"481", "481"}, /* GS1 Belarus */
53 {"482", "482"}, /* GS1 Ukraine */
54 {"484", "484"}, /* GS1 Moldova */
55 {"485", "485"}, /* GS1 Armenia */
56 {"486", "486"}, /* GS1 Georgia */
57 {"487", "487"}, /* GS1 Kazakstan */
58 {"489", "489"}, /* GS1 Hong Kong */
59 {"490", "499"}, /* GS1 Japan */
60 {"500", "509"}, /* GS1 UK */
61 {"520", "520"}, /* GS1 Greece */
62 {"528", "528"}, /* GS1 Lebanon */
63 {"529", "529"}, /* GS1 Cyprus */
64 {"530", "530"}, /* GS1 Albania */
65 {"531", "531"}, /* GS1 MAC (FYR Macedonia) */
66 {"535", "535"}, /* GS1 Malta */
67 {"539", "539"}, /* GS1 Ireland */
68 {"540", "549"}, /* GS1 Belgium & Luxembourg */
69 {"560", "560"}, /* GS1 Portugal */
70 {"569", "569"}, /* GS1 Iceland */
71 {"570", "579"}, /* GS1 Denmark */
72 {"590", "590"}, /* GS1 Poland */
73 {"594", "594"}, /* GS1 Romania */
74 {"599", "599"}, /* GS1 Hungary */
75 {"600", "601"}, /* GS1 South Africa */
76 {"603", "603"}, /* GS1 Ghana */
77 {"608", "608"}, /* GS1 Bahrain */
78 {"609", "609"}, /* GS1 Mauritius */
79 {"611", "611"}, /* GS1 Morocco */
80 {"613", "613"}, /* GS1 Algeria */
81 {"616", "616"}, /* GS1 Kenya */
82 {"618", "618"}, /* GS1 Ivory Coast */
83 {"619", "619"}, /* GS1 Tunisia */
84 {"621", "621"}, /* GS1 Syria */
85 {"622", "622"}, /* GS1 Egypt */
86 {"624", "624"}, /* GS1 Libya */
87 {"625", "625"}, /* GS1 Jordan */
88 {"626", "626"}, /* GS1 Iran */
89 {"627", "627"}, /* GS1 Kuwait */
90 {"628", "628"}, /* GS1 Saudi Arabia */
91 {"629", "629"}, /* GS1 Emirates */
92 {"640", "649"}, /* GS1 Finland */
93 {"690", "695"}, /* GS1 China */
94 {"700", "709"}, /* GS1 Norway */
95 {"729", "729"}, /* GS1 Israel */
96 {"730", "739"}, /* GS1 Sweden */
97 {"740", "740"}, /* GS1 Guatemala */
98 {"741", "741"}, /* GS1 El Salvador */
99 {"742", "742"}, /* GS1 Honduras */
100 {"743", "743"}, /* GS1 Nicaragua */
101 {"744", "744"}, /* GS1 Costa Rica */
102 {"745", "745"}, /* GS1 Panama */
103 {"746", "746"}, /* GS1 Republica Dominicana */
104 {"750", "750"}, /* GS1 Mexico */
105 {"754", "755"}, /* GS1 Canada */
106 {"759", "759"}, /* GS1 Venezuela */
107 {"760", "769"}, /* GS1 Schweiz, Suisse, Svizzera */
108 {"770", "770"}, /* GS1 Colombia */
109 {"773", "773"}, /* GS1 Uruguay */
110 {"775", "775"}, /* GS1 Peru */
111 {"777", "777"}, /* GS1 Bolivia */
112 {"779", "779"}, /* GS1 Argentina */
113 {"780", "780"}, /* GS1 Chile */
114 {"784", "784"}, /* GS1 Paraguay */
115 {"786", "786"}, /* GS1 Ecuador */
116 {"789", "790"}, /* GS1 Brasil */
117 {"800", "839"}, /* GS1 Italy */
118 {"840", "849"}, /* GS1 Spain */
119 {"850", "850"}, /* GS1 Cuba */
120 {"858", "858"}, /* GS1 Slovakia */
121 {"859", "859"}, /* GS1 Czech */
122 {"860", "860"}, /* GS1 YU (Serbia & Montenegro) */
123 {"865", "865"}, /* GS1 Mongolia */
124 {"867", "867"}, /* GS1 North Korea */
125 {"869", "869"}, /* GS1 Turkey */
126 {"870", "879"}, /* GS1 Netherlands */
127 {"880", "880"}, /* GS1 South Korea */
128 {"884", "884"}, /* GS1 Cambodia */
129 {"885", "885"}, /* GS1 Thailand */
130 {"888", "888"}, /* GS1 Singapore */
131 {"890", "890"}, /* GS1 India */
132 {"893", "893"}, /* GS1 Vietnam */
133 {"899", "899"}, /* GS1 Indonesia */
134 {"900", "919"}, /* GS1 Austria */
135 {"930", "939"}, /* GS1 Australia */
136 {"940", "949"}, /* GS1 New Zealand */
137 {"950", "950"}, /* GS1 Head Office */
138 {"955", "955"}, /* GS1 Malaysia */
139 {"958", "958"}, /* GS1 Macau */
140 {"977", "977"}, /* Serial publications (ISSN) */
141 {"978", "978"}, /* Bookland (ISBN) */
142 {"979", "979"}, /* International Standard Music Number (ISMN)
143 * and ISBN contingent */
144 {"980", "980"}, /* Refund receipts */
145 {"981", "982"}, /* Common Currency Coupons */
146 {"990", "999"}, /* Coupons */
147 {NULL, NULL}