1/* contrib/isn/isn--1.0--1.1.sql */ 2 3-- complain if script is sourced in psql, rather than via ALTER EXTENSION 4\echo Use "ALTER EXTENSION isn UPDATE TO '1.1'" to load this file. \quit 5 6ALTER FUNCTION ean13_in(cstring) PARALLEL SAFE; 7ALTER FUNCTION ean13_out(ean13) PARALLEL SAFE; 8ALTER FUNCTION isbn13_in(cstring) PARALLEL SAFE; 9ALTER FUNCTION ean13_out(isbn13) PARALLEL SAFE; 10ALTER FUNCTION ismn13_in(cstring) PARALLEL SAFE; 11ALTER FUNCTION ean13_out(ismn13) PARALLEL SAFE; 12ALTER FUNCTION issn13_in(cstring) PARALLEL SAFE; 13ALTER FUNCTION ean13_out(issn13) PARALLEL SAFE; 14ALTER FUNCTION isbn_in(cstring) PARALLEL SAFE; 15ALTER FUNCTION isn_out(isbn) PARALLEL SAFE; 16ALTER FUNCTION ismn_in(cstring) PARALLEL SAFE; 17ALTER FUNCTION isn_out(ismn) PARALLEL SAFE; 18ALTER FUNCTION issn_in(cstring) PARALLEL SAFE; 19ALTER FUNCTION isn_out(issn) PARALLEL SAFE; 20ALTER FUNCTION upc_in(cstring) PARALLEL SAFE; 21ALTER FUNCTION isn_out(upc) PARALLEL SAFE; 22ALTER FUNCTION isnlt(ean13, ean13) PARALLEL SAFE; 23ALTER FUNCTION isnle(ean13, ean13) PARALLEL SAFE; 24ALTER FUNCTION isneq(ean13, ean13) PARALLEL SAFE; 25ALTER FUNCTION isnge(ean13, ean13) PARALLEL SAFE; 26ALTER FUNCTION isngt(ean13, ean13) PARALLEL SAFE; 27ALTER FUNCTION isnne(ean13, ean13) PARALLEL SAFE; 28ALTER FUNCTION isnlt(ean13, isbn13) PARALLEL SAFE; 29ALTER FUNCTION isnle(ean13, isbn13) PARALLEL SAFE; 30ALTER FUNCTION isneq(ean13, isbn13) PARALLEL SAFE; 31ALTER FUNCTION isnge(ean13, isbn13) PARALLEL SAFE; 32ALTER FUNCTION isngt(ean13, isbn13) PARALLEL SAFE; 33ALTER FUNCTION isnne(ean13, isbn13) PARALLEL SAFE; 34ALTER FUNCTION isnlt(ean13, ismn13) PARALLEL SAFE; 35ALTER FUNCTION isnle(ean13, ismn13) PARALLEL SAFE; 36ALTER FUNCTION isneq(ean13, ismn13) PARALLEL SAFE; 37ALTER FUNCTION isnge(ean13, ismn13) PARALLEL SAFE; 38ALTER FUNCTION isngt(ean13, ismn13) PARALLEL SAFE; 39ALTER FUNCTION isnne(ean13, ismn13) PARALLEL SAFE; 40ALTER FUNCTION isnlt(ean13, issn13) PARALLEL SAFE; 41ALTER FUNCTION isnle(ean13, issn13) PARALLEL SAFE; 42ALTER FUNCTION isneq(ean13, issn13) PARALLEL SAFE; 43ALTER FUNCTION isnge(ean13, issn13) PARALLEL SAFE; 44ALTER FUNCTION isngt(ean13, issn13) PARALLEL SAFE; 45ALTER FUNCTION isnne(ean13, issn13) PARALLEL SAFE; 46ALTER FUNCTION isnlt(ean13, isbn) PARALLEL SAFE; 47ALTER FUNCTION isnle(ean13, isbn) PARALLEL SAFE; 48ALTER FUNCTION isneq(ean13, isbn) PARALLEL SAFE; 49ALTER FUNCTION isnge(ean13, isbn) PARALLEL SAFE; 50ALTER FUNCTION isngt(ean13, isbn) PARALLEL SAFE; 51ALTER FUNCTION isnne(ean13, isbn) PARALLEL SAFE; 52ALTER FUNCTION isnlt(ean13, ismn) PARALLEL SAFE; 53ALTER FUNCTION isnle(ean13, ismn) PARALLEL SAFE; 54ALTER FUNCTION isneq(ean13, ismn) PARALLEL SAFE; 55ALTER FUNCTION isnge(ean13, ismn) PARALLEL SAFE; 56ALTER FUNCTION isngt(ean13, ismn) PARALLEL SAFE; 57ALTER FUNCTION isnne(ean13, ismn) PARALLEL SAFE; 58ALTER FUNCTION isnlt(ean13, issn) PARALLEL SAFE; 59ALTER FUNCTION isnle(ean13, issn) PARALLEL SAFE; 60ALTER FUNCTION isneq(ean13, issn) PARALLEL SAFE; 61ALTER FUNCTION isnge(ean13, issn) PARALLEL SAFE; 62ALTER FUNCTION isngt(ean13, issn) PARALLEL SAFE; 63ALTER FUNCTION isnne(ean13, issn) PARALLEL SAFE; 64ALTER FUNCTION isnlt(ean13, upc) PARALLEL SAFE; 65ALTER FUNCTION isnle(ean13, upc) PARALLEL SAFE; 66ALTER FUNCTION isneq(ean13, upc) PARALLEL SAFE; 67ALTER FUNCTION isnge(ean13, upc) PARALLEL SAFE; 68ALTER FUNCTION isngt(ean13, upc) PARALLEL SAFE; 69ALTER FUNCTION isnne(ean13, upc) PARALLEL SAFE; 70ALTER FUNCTION isnlt(isbn13, isbn13) PARALLEL SAFE; 71ALTER FUNCTION isnle(isbn13, isbn13) PARALLEL SAFE; 72ALTER FUNCTION isneq(isbn13, isbn13) PARALLEL SAFE; 73ALTER FUNCTION isnge(isbn13, isbn13) PARALLEL SAFE; 74ALTER FUNCTION isngt(isbn13, isbn13) PARALLEL SAFE; 75ALTER FUNCTION isnne(isbn13, isbn13) PARALLEL SAFE; 76ALTER FUNCTION isnlt(isbn13, isbn) PARALLEL SAFE; 77ALTER FUNCTION isnle(isbn13, isbn) PARALLEL SAFE; 78ALTER FUNCTION isneq(isbn13, isbn) PARALLEL SAFE; 79ALTER FUNCTION isnge(isbn13, isbn) PARALLEL SAFE; 80ALTER FUNCTION isngt(isbn13, isbn) PARALLEL SAFE; 81ALTER FUNCTION isnne(isbn13, isbn) PARALLEL SAFE; 82ALTER FUNCTION isnlt(isbn13, ean13) PARALLEL SAFE; 83ALTER FUNCTION isnle(isbn13, ean13) PARALLEL SAFE; 84ALTER FUNCTION isneq(isbn13, ean13) PARALLEL SAFE; 85ALTER FUNCTION isnge(isbn13, ean13) PARALLEL SAFE; 86ALTER FUNCTION isngt(isbn13, ean13) PARALLEL SAFE; 87ALTER FUNCTION isnne(isbn13, ean13) PARALLEL SAFE; 88ALTER FUNCTION isnlt(isbn, isbn) PARALLEL SAFE; 89ALTER FUNCTION isnle(isbn, isbn) PARALLEL SAFE; 90ALTER FUNCTION isneq(isbn, isbn) PARALLEL SAFE; 91ALTER FUNCTION isnge(isbn, isbn) PARALLEL SAFE; 92ALTER FUNCTION isngt(isbn, isbn) PARALLEL SAFE; 93ALTER FUNCTION isnne(isbn, isbn) PARALLEL SAFE; 94ALTER FUNCTION isnlt(isbn, isbn13) PARALLEL SAFE; 95ALTER FUNCTION isnle(isbn, isbn13) PARALLEL SAFE; 96ALTER FUNCTION isneq(isbn, isbn13) PARALLEL SAFE; 97ALTER FUNCTION isnge(isbn, isbn13) PARALLEL SAFE; 98ALTER FUNCTION isngt(isbn, isbn13) PARALLEL SAFE; 99ALTER FUNCTION isnne(isbn, isbn13) PARALLEL SAFE; 100ALTER FUNCTION isnlt(isbn, ean13) PARALLEL SAFE; 101ALTER FUNCTION isnle(isbn, ean13) PARALLEL SAFE; 102ALTER FUNCTION isneq(isbn, ean13) PARALLEL SAFE; 103ALTER FUNCTION isnge(isbn, ean13) PARALLEL SAFE; 104ALTER FUNCTION isngt(isbn, ean13) PARALLEL SAFE; 105ALTER FUNCTION isnne(isbn, ean13) PARALLEL SAFE; 106ALTER FUNCTION isnlt(ismn13, ismn13) PARALLEL SAFE; 107ALTER FUNCTION isnle(ismn13, ismn13) PARALLEL SAFE; 108ALTER FUNCTION isneq(ismn13, ismn13) PARALLEL SAFE; 109ALTER FUNCTION isnge(ismn13, ismn13) PARALLEL SAFE; 110ALTER FUNCTION isngt(ismn13, ismn13) PARALLEL SAFE; 111ALTER FUNCTION isnne(ismn13, ismn13) PARALLEL SAFE; 112ALTER FUNCTION isnlt(ismn13, ismn) PARALLEL SAFE; 113ALTER FUNCTION isnle(ismn13, ismn) PARALLEL SAFE; 114ALTER FUNCTION isneq(ismn13, ismn) PARALLEL SAFE; 115ALTER FUNCTION isnge(ismn13, ismn) PARALLEL SAFE; 116ALTER FUNCTION isngt(ismn13, ismn) PARALLEL SAFE; 117ALTER FUNCTION isnne(ismn13, ismn) PARALLEL SAFE; 118ALTER FUNCTION isnlt(ismn13, ean13) PARALLEL SAFE; 119ALTER FUNCTION isnle(ismn13, ean13) PARALLEL SAFE; 120ALTER FUNCTION isneq(ismn13, ean13) PARALLEL SAFE; 121ALTER FUNCTION isnge(ismn13, ean13) PARALLEL SAFE; 122ALTER FUNCTION isngt(ismn13, ean13) PARALLEL SAFE; 123ALTER FUNCTION isnne(ismn13, ean13) PARALLEL SAFE; 124ALTER FUNCTION isnlt(ismn, ismn) PARALLEL SAFE; 125ALTER FUNCTION isnle(ismn, ismn) PARALLEL SAFE; 126ALTER FUNCTION isneq(ismn, ismn) PARALLEL SAFE; 127ALTER FUNCTION isnge(ismn, ismn) PARALLEL SAFE; 128ALTER FUNCTION isngt(ismn, ismn) PARALLEL SAFE; 129ALTER FUNCTION isnne(ismn, ismn) PARALLEL SAFE; 130ALTER FUNCTION isnlt(ismn, ismn13) PARALLEL SAFE; 131ALTER FUNCTION isnle(ismn, ismn13) PARALLEL SAFE; 132ALTER FUNCTION isneq(ismn, ismn13) PARALLEL SAFE; 133ALTER FUNCTION isnge(ismn, ismn13) PARALLEL SAFE; 134ALTER FUNCTION isngt(ismn, ismn13) PARALLEL SAFE; 135ALTER FUNCTION isnne(ismn, ismn13) PARALLEL SAFE; 136ALTER FUNCTION isnlt(ismn, ean13) PARALLEL SAFE; 137ALTER FUNCTION isnle(ismn, ean13) PARALLEL SAFE; 138ALTER FUNCTION isneq(ismn, ean13) PARALLEL SAFE; 139ALTER FUNCTION isnge(ismn, ean13) PARALLEL SAFE; 140ALTER FUNCTION isngt(ismn, ean13) PARALLEL SAFE; 141ALTER FUNCTION isnne(ismn, ean13) PARALLEL SAFE; 142ALTER FUNCTION isnlt(issn13, issn13) PARALLEL SAFE; 143ALTER FUNCTION isnle(issn13, issn13) PARALLEL SAFE; 144ALTER FUNCTION isneq(issn13, issn13) PARALLEL SAFE; 145ALTER FUNCTION isnge(issn13, issn13) PARALLEL SAFE; 146ALTER FUNCTION isngt(issn13, issn13) PARALLEL SAFE; 147ALTER FUNCTION isnne(issn13, issn13) PARALLEL SAFE; 148ALTER FUNCTION isnlt(issn13, issn) PARALLEL SAFE; 149ALTER FUNCTION isnle(issn13, issn) PARALLEL SAFE; 150ALTER FUNCTION isneq(issn13, issn) PARALLEL SAFE; 151ALTER FUNCTION isnge(issn13, issn) PARALLEL SAFE; 152ALTER FUNCTION isngt(issn13, issn) PARALLEL SAFE; 153ALTER FUNCTION isnne(issn13, issn) PARALLEL SAFE; 154ALTER FUNCTION isnlt(issn13, ean13) PARALLEL SAFE; 155ALTER FUNCTION isnle(issn13, ean13) PARALLEL SAFE; 156ALTER FUNCTION isneq(issn13, ean13) PARALLEL SAFE; 157ALTER FUNCTION isnge(issn13, ean13) PARALLEL SAFE; 158ALTER FUNCTION isngt(issn13, ean13) PARALLEL SAFE; 159ALTER FUNCTION isnne(issn13, ean13) PARALLEL SAFE; 160ALTER FUNCTION isnlt(issn, issn) PARALLEL SAFE; 161ALTER FUNCTION isnle(issn, issn) PARALLEL SAFE; 162ALTER FUNCTION isneq(issn, issn) PARALLEL SAFE; 163ALTER FUNCTION isnge(issn, issn) PARALLEL SAFE; 164ALTER FUNCTION isngt(issn, issn) PARALLEL SAFE; 165ALTER FUNCTION isnne(issn, issn) PARALLEL SAFE; 166ALTER FUNCTION isnlt(issn, issn13) PARALLEL SAFE; 167ALTER FUNCTION isnle(issn, issn13) PARALLEL SAFE; 168ALTER FUNCTION isneq(issn, issn13) PARALLEL SAFE; 169ALTER FUNCTION isnge(issn, issn13) PARALLEL SAFE; 170ALTER FUNCTION isngt(issn, issn13) PARALLEL SAFE; 171ALTER FUNCTION isnne(issn, issn13) PARALLEL SAFE; 172ALTER FUNCTION isnlt(issn, ean13) PARALLEL SAFE; 173ALTER FUNCTION isnle(issn, ean13) PARALLEL SAFE; 174ALTER FUNCTION isneq(issn, ean13) PARALLEL SAFE; 175ALTER FUNCTION isnge(issn, ean13) PARALLEL SAFE; 176ALTER FUNCTION isngt(issn, ean13) PARALLEL SAFE; 177ALTER FUNCTION isnne(issn, ean13) PARALLEL SAFE; 178ALTER FUNCTION isnlt(upc, upc) PARALLEL SAFE; 179ALTER FUNCTION isnle(upc, upc) PARALLEL SAFE; 180ALTER FUNCTION isneq(upc, upc) PARALLEL SAFE; 181ALTER FUNCTION isnge(upc, upc) PARALLEL SAFE; 182ALTER FUNCTION isngt(upc, upc) PARALLEL SAFE; 183ALTER FUNCTION isnne(upc, upc) PARALLEL SAFE; 184ALTER FUNCTION isnlt(upc, ean13) PARALLEL SAFE; 185ALTER FUNCTION isnle(upc, ean13) PARALLEL SAFE; 186ALTER FUNCTION isneq(upc, ean13) PARALLEL SAFE; 187ALTER FUNCTION isnge(upc, ean13) PARALLEL SAFE; 188ALTER FUNCTION isngt(upc, ean13) PARALLEL SAFE; 189ALTER FUNCTION isnne(upc, ean13) PARALLEL SAFE; 190ALTER FUNCTION btean13cmp(ean13, ean13) PARALLEL SAFE; 191ALTER FUNCTION hashean13(ean13) PARALLEL SAFE; 192ALTER FUNCTION btean13cmp(ean13, isbn13) PARALLEL SAFE; 193ALTER FUNCTION btean13cmp(ean13, ismn13) PARALLEL SAFE; 194ALTER FUNCTION btean13cmp(ean13, issn13) PARALLEL SAFE; 195ALTER FUNCTION btean13cmp(ean13, isbn) PARALLEL SAFE; 196ALTER FUNCTION btean13cmp(ean13, ismn) PARALLEL SAFE; 197ALTER FUNCTION btean13cmp(ean13, issn) PARALLEL SAFE; 198ALTER FUNCTION btean13cmp(ean13, upc) PARALLEL SAFE; 199ALTER FUNCTION btisbn13cmp(isbn13, isbn13) PARALLEL SAFE; 200ALTER FUNCTION hashisbn13(isbn13) PARALLEL SAFE; 201ALTER FUNCTION btisbn13cmp(isbn13, ean13) PARALLEL SAFE; 202ALTER FUNCTION btisbn13cmp(isbn13, isbn) PARALLEL SAFE; 203ALTER FUNCTION btisbncmp(isbn, isbn) PARALLEL SAFE; 204ALTER FUNCTION hashisbn(isbn) PARALLEL SAFE; 205ALTER FUNCTION btisbncmp(isbn, ean13) PARALLEL SAFE; 206ALTER FUNCTION btisbncmp(isbn, isbn13) PARALLEL SAFE; 207ALTER FUNCTION btismn13cmp(ismn13, ismn13) PARALLEL SAFE; 208ALTER FUNCTION hashismn13(ismn13) PARALLEL SAFE; 209ALTER FUNCTION btismn13cmp(ismn13, ean13) PARALLEL SAFE; 210ALTER FUNCTION btismn13cmp(ismn13, ismn) PARALLEL SAFE; 211ALTER FUNCTION btismncmp(ismn, ismn) PARALLEL SAFE; 212ALTER FUNCTION hashismn(ismn) PARALLEL SAFE; 213ALTER FUNCTION btismncmp(ismn, ean13) PARALLEL SAFE; 214ALTER FUNCTION btismncmp(ismn, ismn13) PARALLEL SAFE; 215ALTER FUNCTION btissn13cmp(issn13, issn13) PARALLEL SAFE; 216ALTER FUNCTION hashissn13(issn13) PARALLEL SAFE; 217ALTER FUNCTION btissn13cmp(issn13, ean13) PARALLEL SAFE; 218ALTER FUNCTION btissn13cmp(issn13, issn) PARALLEL SAFE; 219ALTER FUNCTION btissncmp(issn, issn) PARALLEL SAFE; 220ALTER FUNCTION hashissn(issn) PARALLEL SAFE; 221ALTER FUNCTION btissncmp(issn, ean13) PARALLEL SAFE; 222ALTER FUNCTION btissncmp(issn, issn13) PARALLEL SAFE; 223ALTER FUNCTION btupccmp(upc, upc) PARALLEL SAFE; 224ALTER FUNCTION hashupc(upc) PARALLEL SAFE; 225ALTER FUNCTION btupccmp(upc, ean13) PARALLEL SAFE; 226ALTER FUNCTION isbn13(ean13) PARALLEL SAFE; 227ALTER FUNCTION ismn13(ean13) PARALLEL SAFE; 228ALTER FUNCTION issn13(ean13) PARALLEL SAFE; 229ALTER FUNCTION isbn(ean13) PARALLEL SAFE; 230ALTER FUNCTION ismn(ean13) PARALLEL SAFE; 231ALTER FUNCTION issn(ean13) PARALLEL SAFE; 232ALTER FUNCTION upc(ean13) PARALLEL SAFE; 233ALTER FUNCTION make_valid(ean13) PARALLEL SAFE; 234ALTER FUNCTION make_valid(isbn13) PARALLEL SAFE; 235ALTER FUNCTION make_valid(ismn13) PARALLEL SAFE; 236ALTER FUNCTION make_valid(issn13) PARALLEL SAFE; 237ALTER FUNCTION make_valid(isbn) PARALLEL SAFE; 238ALTER FUNCTION make_valid(ismn) PARALLEL SAFE; 239ALTER FUNCTION make_valid(issn) PARALLEL SAFE; 240ALTER FUNCTION make_valid(upc) PARALLEL SAFE; 241ALTER FUNCTION is_valid(ean13) PARALLEL SAFE; 242ALTER FUNCTION is_valid(isbn13) PARALLEL SAFE; 243ALTER FUNCTION is_valid(ismn13) PARALLEL SAFE; 244ALTER FUNCTION is_valid(issn13) PARALLEL SAFE; 245ALTER FUNCTION is_valid(isbn) PARALLEL SAFE; 246ALTER FUNCTION is_valid(ismn) PARALLEL SAFE; 247ALTER FUNCTION is_valid(issn) PARALLEL SAFE; 248ALTER FUNCTION is_valid(upc) PARALLEL SAFE; 249ALTER FUNCTION isn_weak(boolean) PARALLEL RESTRICTED; 250ALTER FUNCTION isn_weak() PARALLEL RESTRICTED; 251