1-- ip4r extension 2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION 4\echo Use "CREATE EXTENSION ip4r" to load this file. \quit 5 6ALTER EXTENSION ip4r ADD FUNCTION ip4_in(cstring); 7ALTER EXTENSION ip4r ADD FUNCTION ip4_out(ip4); 8ALTER EXTENSION ip4r ADD FUNCTION ip4_recv(internal); 9ALTER EXTENSION ip4r ADD FUNCTION ip4_send(ip4); 10ALTER EXTENSION ip4r ADD TYPE ip4; 11ALTER EXTENSION ip4r ADD FUNCTION ip4r_in(cstring); 12ALTER EXTENSION ip4r ADD FUNCTION ip4r_out(ip4r); 13ALTER EXTENSION ip4r ADD FUNCTION ip4r_recv(internal); 14ALTER EXTENSION ip4r ADD FUNCTION ip4r_send(ip4r); 15ALTER EXTENSION ip4r ADD TYPE ip4r; 16ALTER EXTENSION ip4r ADD FUNCTION ip6_in(cstring); 17ALTER EXTENSION ip4r ADD FUNCTION ip6_out(ip6); 18ALTER EXTENSION ip4r ADD FUNCTION ip6_recv(internal); 19ALTER EXTENSION ip4r ADD FUNCTION ip6_send(ip6); 20ALTER EXTENSION ip4r ADD TYPE ip6; 21ALTER EXTENSION ip4r ADD FUNCTION ip6r_in(cstring); 22ALTER EXTENSION ip4r ADD FUNCTION ip6r_out(ip6r); 23ALTER EXTENSION ip4r ADD FUNCTION ip6r_recv(internal); 24ALTER EXTENSION ip4r ADD FUNCTION ip6r_send(ip6r); 25ALTER EXTENSION ip4r ADD TYPE ip6r; 26ALTER EXTENSION ip4r ADD FUNCTION ipaddress_in(cstring); 27ALTER EXTENSION ip4r ADD FUNCTION ipaddress_out(ipaddress); 28ALTER EXTENSION ip4r ADD FUNCTION ipaddress_recv(internal); 29ALTER EXTENSION ip4r ADD FUNCTION ipaddress_send(ipaddress); 30ALTER EXTENSION ip4r ADD TYPE ipaddress; 31ALTER EXTENSION ip4r ADD FUNCTION iprange_in(cstring); 32ALTER EXTENSION ip4r ADD FUNCTION iprange_out(iprange); 33ALTER EXTENSION ip4r ADD FUNCTION iprange_recv(internal); 34ALTER EXTENSION ip4r ADD FUNCTION iprange_send(iprange); 35ALTER EXTENSION ip4r ADD TYPE iprange; 36ALTER EXTENSION ip4r ADD FUNCTION ip4(bigint); 37ALTER EXTENSION ip4r ADD FUNCTION ip4(double precision); 38ALTER EXTENSION ip4r ADD FUNCTION ip4(numeric); 39ALTER EXTENSION ip4r ADD FUNCTION ip4(inet); 40ALTER EXTENSION ip4r ADD FUNCTION ip4(text); 41ALTER EXTENSION ip4r ADD FUNCTION ip4(ipaddress); 42ALTER EXTENSION ip4r ADD FUNCTION ip6(numeric); 43ALTER EXTENSION ip4r ADD FUNCTION ip6(inet); 44ALTER EXTENSION ip4r ADD FUNCTION ip6(text); 45ALTER EXTENSION ip4r ADD FUNCTION ip6(ipaddress); 46ALTER EXTENSION ip4r ADD FUNCTION ipaddress(inet); 47ALTER EXTENSION ip4r ADD FUNCTION ipaddress(ip4); 48ALTER EXTENSION ip4r ADD FUNCTION ipaddress(ip6); 49ALTER EXTENSION ip4r ADD FUNCTION ipaddress(text); 50ALTER EXTENSION ip4r ADD FUNCTION ip4r(cidr); 51ALTER EXTENSION ip4r ADD FUNCTION ip4r(ip4); 52ALTER EXTENSION ip4r ADD FUNCTION ip4r(text); 53ALTER EXTENSION ip4r ADD FUNCTION ip4r(iprange); 54ALTER EXTENSION ip4r ADD FUNCTION ip6r(cidr); 55ALTER EXTENSION ip4r ADD FUNCTION ip6r(ip6); 56ALTER EXTENSION ip4r ADD FUNCTION ip6r(text); 57ALTER EXTENSION ip4r ADD FUNCTION ip6r(iprange); 58ALTER EXTENSION ip4r ADD FUNCTION iprange(cidr); 59ALTER EXTENSION ip4r ADD FUNCTION iprange(ip4); 60ALTER EXTENSION ip4r ADD FUNCTION iprange(ip6); 61ALTER EXTENSION ip4r ADD FUNCTION iprange(ip4r); 62ALTER EXTENSION ip4r ADD FUNCTION iprange(ip6r); 63ALTER EXTENSION ip4r ADD FUNCTION iprange(ipaddress); 64ALTER EXTENSION ip4r ADD FUNCTION iprange(text); 65ALTER EXTENSION ip4r ADD FUNCTION cidr(ip4); 66ALTER EXTENSION ip4r ADD FUNCTION cidr(ip4r); 67ALTER EXTENSION ip4r ADD FUNCTION cidr(ip6); 68ALTER EXTENSION ip4r ADD FUNCTION cidr(ip6r); 69ALTER EXTENSION ip4r ADD FUNCTION cidr(ipaddress); 70ALTER EXTENSION ip4r ADD FUNCTION cidr(iprange); 71ALTER EXTENSION ip4r ADD FUNCTION text(ip4); 72ALTER EXTENSION ip4r ADD FUNCTION text(ip4r); 73ALTER EXTENSION ip4r ADD FUNCTION text(ip6); 74ALTER EXTENSION ip4r ADD FUNCTION text(ip6r); 75ALTER EXTENSION ip4r ADD FUNCTION text(ipaddress); 76ALTER EXTENSION ip4r ADD FUNCTION text(iprange); 77ALTER EXTENSION ip4r ADD FUNCTION to_bigint(ip4); 78ALTER EXTENSION ip4r ADD FUNCTION to_double(ip4); 79ALTER EXTENSION ip4r ADD FUNCTION to_numeric(ip4); 80ALTER EXTENSION ip4r ADD FUNCTION to_numeric(ip6); 81ALTER EXTENSION ip4r ADD FUNCTION to_numeric(ipaddress); 82ALTER EXTENSION ip4r ADD CAST (ip4 as bigint); 83ALTER EXTENSION ip4r ADD CAST (ip4 as double precision); 84ALTER EXTENSION ip4r ADD CAST (ip4 as numeric); 85ALTER EXTENSION ip4r ADD CAST (ip4 as text); 86ALTER EXTENSION ip4r ADD CAST (ip4 as cidr); 87ALTER EXTENSION ip4r ADD CAST (ip4r as cidr); 88ALTER EXTENSION ip4r ADD CAST (ip4r as text); 89ALTER EXTENSION ip4r ADD CAST (ip6 as numeric); 90ALTER EXTENSION ip4r ADD CAST (ip6 as text); 91ALTER EXTENSION ip4r ADD CAST (ip6 as cidr); 92ALTER EXTENSION ip4r ADD CAST (ip6r as cidr); 93ALTER EXTENSION ip4r ADD CAST (ip6r as text); 94ALTER EXTENSION ip4r ADD CAST (ipaddress as numeric); 95ALTER EXTENSION ip4r ADD CAST (ipaddress as text); 96ALTER EXTENSION ip4r ADD CAST (ipaddress as cidr); 97ALTER EXTENSION ip4r ADD CAST (iprange as cidr); 98ALTER EXTENSION ip4r ADD CAST (iprange as text); 99ALTER EXTENSION ip4r ADD CAST (text as ip4); 100ALTER EXTENSION ip4r ADD CAST (text as ip4r); 101ALTER EXTENSION ip4r ADD CAST (text as ip6); 102ALTER EXTENSION ip4r ADD CAST (text as ip6r); 103ALTER EXTENSION ip4r ADD CAST (text as ipaddress); 104ALTER EXTENSION ip4r ADD CAST (text as iprange); 105ALTER EXTENSION ip4r ADD CAST (bigint as ip4); 106ALTER EXTENSION ip4r ADD CAST (double precision as ip4); 107ALTER EXTENSION ip4r ADD CAST (numeric as ip4); 108ALTER EXTENSION ip4r ADD CAST (numeric as ip6); 109ALTER EXTENSION ip4r ADD CAST (cidr as ip4r); 110ALTER EXTENSION ip4r ADD CAST (cidr as ip6r); 111ALTER EXTENSION ip4r ADD CAST (cidr as iprange); 112ALTER EXTENSION ip4r ADD CAST (inet as ip4); 113ALTER EXTENSION ip4r ADD CAST (inet as ip6); 114ALTER EXTENSION ip4r ADD CAST (inet as ipaddress); 115ALTER EXTENSION ip4r ADD CAST (ip4 as ip4r); 116ALTER EXTENSION ip4r ADD CAST (ip4 as ipaddress); 117ALTER EXTENSION ip4r ADD CAST (ip4 as iprange); 118ALTER EXTENSION ip4r ADD CAST (ip4r as iprange); 119ALTER EXTENSION ip4r ADD CAST (ip6 as ip6r); 120ALTER EXTENSION ip4r ADD CAST (ip6 as ipaddress); 121ALTER EXTENSION ip4r ADD CAST (ip6 as iprange); 122ALTER EXTENSION ip4r ADD CAST (ip6r as iprange); 123ALTER EXTENSION ip4r ADD CAST (ipaddress as iprange); 124ALTER EXTENSION ip4r ADD CAST (ipaddress as ip4); 125ALTER EXTENSION ip4r ADD CAST (ipaddress as ip6); 126ALTER EXTENSION ip4r ADD CAST (iprange as ip4r); 127ALTER EXTENSION ip4r ADD CAST (iprange as ip6r); 128ALTER EXTENSION ip4r ADD FUNCTION ip4r(ip4,ip4); 129ALTER EXTENSION ip4r ADD FUNCTION ip6r(ip6,ip6); 130ALTER EXTENSION ip4r ADD FUNCTION iprange(ip4,ip4); 131ALTER EXTENSION ip4r ADD FUNCTION iprange(ip6,ip6); 132ALTER EXTENSION ip4r ADD FUNCTION iprange(ipaddress,ipaddress); 133ALTER EXTENSION ip4r ADD FUNCTION family(ip4); 134ALTER EXTENSION ip4r ADD FUNCTION family(ip4r); 135ALTER EXTENSION ip4r ADD FUNCTION family(ip6); 136ALTER EXTENSION ip4r ADD FUNCTION family(ip6r); 137ALTER EXTENSION ip4r ADD FUNCTION family(ipaddress); 138ALTER EXTENSION ip4r ADD FUNCTION family(iprange); 139ALTER EXTENSION ip4r ADD FUNCTION ip4_netmask(integer); 140ALTER EXTENSION ip4r ADD FUNCTION ip6_netmask(integer); 141ALTER EXTENSION ip4r ADD FUNCTION is_cidr(ip4r); 142ALTER EXTENSION ip4r ADD FUNCTION is_cidr(ip6r); 143ALTER EXTENSION ip4r ADD FUNCTION is_cidr(iprange); 144ALTER EXTENSION ip4r ADD FUNCTION masklen(ip4r); 145ALTER EXTENSION ip4r ADD FUNCTION masklen(ip6r); 146ALTER EXTENSION ip4r ADD FUNCTION masklen(iprange); 147ALTER EXTENSION ip4r ADD FUNCTION lower(ip4r); 148ALTER EXTENSION ip4r ADD FUNCTION lower(ip6r); 149ALTER EXTENSION ip4r ADD FUNCTION lower(iprange); 150ALTER EXTENSION ip4r ADD FUNCTION upper(ip4r); 151ALTER EXTENSION ip4r ADD FUNCTION upper(ip6r); 152ALTER EXTENSION ip4r ADD FUNCTION upper(iprange); 153ALTER EXTENSION ip4r ADD FUNCTION ip4_net_lower(ip4,integer); 154ALTER EXTENSION ip4r ADD FUNCTION ip6_net_lower(ip6,integer); 155ALTER EXTENSION ip4r ADD FUNCTION ipaddress_net_lower(ipaddress,integer); 156ALTER EXTENSION ip4r ADD FUNCTION ip4_net_upper(ip4,integer); 157ALTER EXTENSION ip4r ADD FUNCTION ip6_net_upper(ip6,integer); 158ALTER EXTENSION ip4r ADD FUNCTION ipaddress_net_upper(ipaddress,integer); 159ALTER EXTENSION ip4r ADD FUNCTION ip4r_union(ip4r, ip4r); 160ALTER EXTENSION ip4r ADD FUNCTION ip6r_union(ip6r, ip6r); 161ALTER EXTENSION ip4r ADD FUNCTION iprange_union(iprange, iprange); 162ALTER EXTENSION ip4r ADD FUNCTION ip4r_inter(ip4r,ip4r); 163ALTER EXTENSION ip4r ADD FUNCTION ip6r_inter(ip6r,ip6r); 164ALTER EXTENSION ip4r ADD FUNCTION iprange_inter(iprange,iprange); 165ALTER EXTENSION ip4r ADD FUNCTION ip4r_net_mask(ip4,ip4); 166ALTER EXTENSION ip4r ADD FUNCTION ip6r_net_mask(ip6,ip6); 167ALTER EXTENSION ip4r ADD FUNCTION iprange_net_mask(ip4,ip4); 168ALTER EXTENSION ip4r ADD FUNCTION iprange_net_mask(ip6,ip6); 169ALTER EXTENSION ip4r ADD FUNCTION iprange_net_mask(ipaddress,ipaddress); 170ALTER EXTENSION ip4r ADD FUNCTION ip4r_net_prefix(ip4,integer); 171ALTER EXTENSION ip4r ADD FUNCTION ip6r_net_prefix(ip6,integer); 172ALTER EXTENSION ip4r ADD FUNCTION iprange_net_prefix(ip4,integer); 173ALTER EXTENSION ip4r ADD FUNCTION iprange_net_prefix(ip6,integer); 174ALTER EXTENSION ip4r ADD FUNCTION iprange_net_prefix(ipaddress,integer); 175ALTER EXTENSION ip4r ADD OPERATOR /(ip4,ip4); 176ALTER EXTENSION ip4r ADD OPERATOR /(ip6,ip6); 177ALTER EXTENSION ip4r ADD OPERATOR /(ipaddress,ipaddress); 178ALTER EXTENSION ip4r ADD OPERATOR /(ip4,integer); 179ALTER EXTENSION ip4r ADD OPERATOR /(ip6,integer); 180ALTER EXTENSION ip4r ADD OPERATOR /(ipaddress,integer); 181ALTER EXTENSION ip4r ADD FUNCTION ip4r_size(ip4r); 182ALTER EXTENSION ip4r ADD FUNCTION ip6r_size(ip6r); 183ALTER EXTENSION ip4r ADD FUNCTION iprange_size(iprange); 184ALTER EXTENSION ip4r ADD FUNCTION ip4r_size_exact(ip4r); 185ALTER EXTENSION ip4r ADD FUNCTION ip6r_size_exact(ip6r); 186ALTER EXTENSION ip4r ADD FUNCTION iprange_size_exact(iprange); 187ALTER EXTENSION ip4r ADD OPERATOR @(NONE,ip4r); 188ALTER EXTENSION ip4r ADD OPERATOR @(NONE,ip6r); 189ALTER EXTENSION ip4r ADD OPERATOR @(NONE,iprange); 190ALTER EXTENSION ip4r ADD OPERATOR @@(NONE,ip4r); 191ALTER EXTENSION ip4r ADD OPERATOR @@(NONE,ip6r); 192ALTER EXTENSION ip4r ADD OPERATOR @@(NONE,iprange); 193ALTER EXTENSION ip4r ADD FUNCTION ip4_and(ip4,ip4); 194ALTER EXTENSION ip4r ADD FUNCTION ip6_and(ip6,ip6); 195ALTER EXTENSION ip4r ADD FUNCTION ipaddress_and(ipaddress,ipaddress); 196ALTER EXTENSION ip4r ADD OPERATOR &(ip4,ip4); 197ALTER EXTENSION ip4r ADD OPERATOR &(ip6,ip6); 198ALTER EXTENSION ip4r ADD OPERATOR &(ipaddress,ipaddress); 199ALTER EXTENSION ip4r ADD FUNCTION ip4_or(ip4,ip4); 200ALTER EXTENSION ip4r ADD FUNCTION ip6_or(ip6,ip6); 201ALTER EXTENSION ip4r ADD FUNCTION ipaddress_or(ipaddress,ipaddress); 202ALTER EXTENSION ip4r ADD OPERATOR |(ip4,ip4); 203ALTER EXTENSION ip4r ADD OPERATOR |(ip6,ip6); 204ALTER EXTENSION ip4r ADD OPERATOR |(ipaddress,ipaddress); 205ALTER EXTENSION ip4r ADD FUNCTION ip4_not(ip4); 206ALTER EXTENSION ip4r ADD FUNCTION ip6_not(ip6); 207ALTER EXTENSION ip4r ADD FUNCTION ipaddress_not(ipaddress); 208ALTER EXTENSION ip4r ADD OPERATOR ~(NONE,ip4); 209ALTER EXTENSION ip4r ADD OPERATOR ~(NONE,ip6); 210ALTER EXTENSION ip4r ADD OPERATOR ~(NONE,ipaddress); 211ALTER EXTENSION ip4r ADD FUNCTION ip4_xor(ip4,ip4); 212ALTER EXTENSION ip4r ADD FUNCTION ip6_xor(ip6,ip6); 213ALTER EXTENSION ip4r ADD FUNCTION ipaddress_xor(ipaddress,ipaddress); 214ALTER EXTENSION ip4r ADD OPERATOR #(ip4,ip4); 215ALTER EXTENSION ip4r ADD OPERATOR #(ip6,ip6); 216ALTER EXTENSION ip4r ADD OPERATOR #(ipaddress,ipaddress); 217ALTER EXTENSION ip4r ADD FUNCTION ip4_plus_bigint(ip4,bigint); 218ALTER EXTENSION ip4r ADD FUNCTION ip4_plus_int(ip4,integer); 219ALTER EXTENSION ip4r ADD FUNCTION ip4_plus_numeric(ip4,numeric); 220ALTER EXTENSION ip4r ADD OPERATOR +(ip4,bigint); 221ALTER EXTENSION ip4r ADD OPERATOR +(ip4,integer); 222ALTER EXTENSION ip4r ADD OPERATOR +(ip4,numeric); 223ALTER EXTENSION ip4r ADD FUNCTION ip6_plus_bigint(ip6,bigint); 224ALTER EXTENSION ip4r ADD FUNCTION ip6_plus_int(ip6,integer); 225ALTER EXTENSION ip4r ADD FUNCTION ip6_plus_numeric(ip6,numeric); 226ALTER EXTENSION ip4r ADD OPERATOR +(ip6,bigint); 227ALTER EXTENSION ip4r ADD OPERATOR +(ip6,integer); 228ALTER EXTENSION ip4r ADD OPERATOR +(ip6,numeric); 229ALTER EXTENSION ip4r ADD FUNCTION ipaddress_plus_bigint(ipaddress,bigint); 230ALTER EXTENSION ip4r ADD FUNCTION ipaddress_plus_int(ipaddress,integer); 231ALTER EXTENSION ip4r ADD FUNCTION ipaddress_plus_numeric(ipaddress,numeric); 232ALTER EXTENSION ip4r ADD OPERATOR +(ipaddress,bigint); 233ALTER EXTENSION ip4r ADD OPERATOR +(ipaddress,integer); 234ALTER EXTENSION ip4r ADD OPERATOR +(ipaddress,numeric); 235ALTER EXTENSION ip4r ADD FUNCTION ip4_minus_bigint(ip4,bigint); 236ALTER EXTENSION ip4r ADD FUNCTION ip4_minus_int(ip4,integer); 237ALTER EXTENSION ip4r ADD FUNCTION ip4_minus_numeric(ip4,numeric); 238ALTER EXTENSION ip4r ADD OPERATOR -(ip4,bigint); 239ALTER EXTENSION ip4r ADD OPERATOR -(ip4,integer); 240ALTER EXTENSION ip4r ADD OPERATOR -(ip4,numeric); 241ALTER EXTENSION ip4r ADD FUNCTION ip6_minus_bigint(ip6,bigint); 242ALTER EXTENSION ip4r ADD FUNCTION ip6_minus_int(ip6,integer); 243ALTER EXTENSION ip4r ADD FUNCTION ip6_minus_numeric(ip6,numeric); 244ALTER EXTENSION ip4r ADD OPERATOR -(ip6,bigint); 245ALTER EXTENSION ip4r ADD OPERATOR -(ip6,integer); 246ALTER EXTENSION ip4r ADD OPERATOR -(ip6,numeric); 247ALTER EXTENSION ip4r ADD FUNCTION ipaddress_minus_bigint(ipaddress,bigint); 248ALTER EXTENSION ip4r ADD FUNCTION ipaddress_minus_int(ipaddress,integer); 249ALTER EXTENSION ip4r ADD FUNCTION ipaddress_minus_numeric(ipaddress,numeric); 250ALTER EXTENSION ip4r ADD OPERATOR -(ipaddress,bigint); 251ALTER EXTENSION ip4r ADD OPERATOR -(ipaddress,integer); 252ALTER EXTENSION ip4r ADD OPERATOR -(ipaddress,numeric); 253ALTER EXTENSION ip4r ADD FUNCTION ip4_minus_ip4(ip4,ip4); 254ALTER EXTENSION ip4r ADD FUNCTION ip6_minus_ip6(ip6,ip6); 255ALTER EXTENSION ip4r ADD FUNCTION ipaddress_minus_ipaddress(ipaddress,ipaddress); 256ALTER EXTENSION ip4r ADD OPERATOR -(ip4,ip4); 257ALTER EXTENSION ip4r ADD OPERATOR -(ip6,ip6); 258ALTER EXTENSION ip4r ADD OPERATOR -(ipaddress,ipaddress); 259ALTER EXTENSION ip4r ADD FUNCTION ip4r_contained_by(ip4r,ip4r); 260ALTER EXTENSION ip4r ADD FUNCTION ip6r_contained_by(ip6r,ip6r); 261ALTER EXTENSION ip4r ADD FUNCTION iprange_contained_by(iprange,iprange); 262ALTER EXTENSION ip4r ADD OPERATOR <<=(ip4r,ip4r); 263ALTER EXTENSION ip4r ADD OPERATOR <<=(ip6r,ip6r); 264ALTER EXTENSION ip4r ADD OPERATOR <<=(iprange,iprange); 265ALTER EXTENSION ip4r ADD FUNCTION ip4r_contained_by_strict(ip4r,ip4r); 266ALTER EXTENSION ip4r ADD FUNCTION ip6r_contained_by_strict(ip6r,ip6r); 267ALTER EXTENSION ip4r ADD FUNCTION iprange_contained_by_strict(iprange,iprange); 268ALTER EXTENSION ip4r ADD OPERATOR <<(ip4r,ip4r); 269ALTER EXTENSION ip4r ADD OPERATOR <<(ip6r,ip6r); 270ALTER EXTENSION ip4r ADD OPERATOR <<(iprange,iprange); 271ALTER EXTENSION ip4r ADD FUNCTION ip4r_contains(ip4r,ip4r); 272ALTER EXTENSION ip4r ADD FUNCTION ip6r_contains(ip6r,ip6r); 273ALTER EXTENSION ip4r ADD FUNCTION iprange_contains(iprange,iprange); 274ALTER EXTENSION ip4r ADD OPERATOR >>=(ip4r,ip4r); 275ALTER EXTENSION ip4r ADD OPERATOR >>=(ip6r,ip6r); 276ALTER EXTENSION ip4r ADD OPERATOR >>=(iprange,iprange); 277ALTER EXTENSION ip4r ADD FUNCTION ip4r_contains_strict(ip4r,ip4r); 278ALTER EXTENSION ip4r ADD FUNCTION ip6r_contains_strict(ip6r,ip6r); 279ALTER EXTENSION ip4r ADD FUNCTION iprange_contains_strict(iprange,iprange); 280ALTER EXTENSION ip4r ADD OPERATOR >>(ip4r,ip4r); 281ALTER EXTENSION ip4r ADD OPERATOR >>(ip6r,ip6r); 282ALTER EXTENSION ip4r ADD OPERATOR >>(iprange,iprange); 283ALTER EXTENSION ip4r ADD FUNCTION ip4r_overlaps(ip4r,ip4r); 284ALTER EXTENSION ip4r ADD FUNCTION ip6r_overlaps(ip6r,ip6r); 285ALTER EXTENSION ip4r ADD FUNCTION iprange_overlaps(iprange,iprange); 286ALTER EXTENSION ip4r ADD OPERATOR &&(ip4r,ip4r); 287ALTER EXTENSION ip4r ADD OPERATOR &&(ip6r,ip6r); 288ALTER EXTENSION ip4r ADD OPERATOR &&(iprange,iprange); 289ALTER EXTENSION ip4r ADD FUNCTION ip4_contained_by(ip4,ip4r); 290ALTER EXTENSION ip4r ADD FUNCTION ip4_contained_by(ip4,iprange); 291ALTER EXTENSION ip4r ADD FUNCTION ip6_contained_by(ip6,ip6r); 292ALTER EXTENSION ip4r ADD FUNCTION ip6_contained_by(ip6,iprange); 293ALTER EXTENSION ip4r ADD FUNCTION ipaddress_contained_by(ipaddress,iprange); 294ALTER EXTENSION ip4r ADD FUNCTION ip4_contains(ip4r,ip4); 295ALTER EXTENSION ip4r ADD FUNCTION ip6_contains(ip6r,ip6); 296ALTER EXTENSION ip4r ADD FUNCTION ip4_contains(iprange,ip4); 297ALTER EXTENSION ip4r ADD FUNCTION ip6_contains(iprange,ip6); 298ALTER EXTENSION ip4r ADD FUNCTION ipaddress_contains(iprange,ipaddress); 299ALTER EXTENSION ip4r ADD FUNCTION ip4_eq(ip4,ip4); 300ALTER EXTENSION ip4r ADD FUNCTION ip4r_eq(ip4r,ip4r); 301ALTER EXTENSION ip4r ADD FUNCTION ip6_eq(ip6,ip6); 302ALTER EXTENSION ip4r ADD FUNCTION ip6r_eq(ip6r,ip6r); 303ALTER EXTENSION ip4r ADD FUNCTION ipaddress_eq(ipaddress,ipaddress); 304ALTER EXTENSION ip4r ADD FUNCTION iprange_eq(iprange,iprange); 305ALTER EXTENSION ip4r ADD OPERATOR =(ip4,ip4); 306ALTER EXTENSION ip4r ADD OPERATOR =(ip4r,ip4r); 307ALTER EXTENSION ip4r ADD OPERATOR =(ip6,ip6); 308ALTER EXTENSION ip4r ADD OPERATOR =(ip6r,ip6r); 309ALTER EXTENSION ip4r ADD OPERATOR =(ipaddress,ipaddress); 310ALTER EXTENSION ip4r ADD OPERATOR =(iprange,iprange); 311ALTER EXTENSION ip4r ADD FUNCTION ip4_ge(ip4,ip4); 312ALTER EXTENSION ip4r ADD FUNCTION ip4r_ge(ip4r,ip4r); 313ALTER EXTENSION ip4r ADD FUNCTION ip6_ge(ip6,ip6); 314ALTER EXTENSION ip4r ADD FUNCTION ip6r_ge(ip6r,ip6r); 315ALTER EXTENSION ip4r ADD FUNCTION ipaddress_ge(ipaddress,ipaddress); 316ALTER EXTENSION ip4r ADD FUNCTION iprange_ge(iprange,iprange); 317ALTER EXTENSION ip4r ADD OPERATOR >=(ip4,ip4); 318ALTER EXTENSION ip4r ADD OPERATOR >=(ip4r,ip4r); 319ALTER EXTENSION ip4r ADD OPERATOR >=(ip6,ip6); 320ALTER EXTENSION ip4r ADD OPERATOR >=(ip6r,ip6r); 321ALTER EXTENSION ip4r ADD OPERATOR >=(ipaddress,ipaddress); 322ALTER EXTENSION ip4r ADD OPERATOR >=(iprange,iprange); 323ALTER EXTENSION ip4r ADD FUNCTION ip4_gt(ip4,ip4); 324ALTER EXTENSION ip4r ADD FUNCTION ip4r_gt(ip4r,ip4r); 325ALTER EXTENSION ip4r ADD FUNCTION ip6_gt(ip6,ip6); 326ALTER EXTENSION ip4r ADD FUNCTION ip6r_gt(ip6r,ip6r); 327ALTER EXTENSION ip4r ADD FUNCTION ipaddress_gt(ipaddress,ipaddress); 328ALTER EXTENSION ip4r ADD FUNCTION iprange_gt(iprange,iprange); 329ALTER EXTENSION ip4r ADD OPERATOR >(ip4,ip4); 330ALTER EXTENSION ip4r ADD OPERATOR >(ip4r,ip4r); 331ALTER EXTENSION ip4r ADD OPERATOR >(ip6,ip6); 332ALTER EXTENSION ip4r ADD OPERATOR >(ip6r,ip6r); 333ALTER EXTENSION ip4r ADD OPERATOR >(ipaddress,ipaddress); 334ALTER EXTENSION ip4r ADD OPERATOR >(iprange,iprange); 335ALTER EXTENSION ip4r ADD FUNCTION ip4_le(ip4,ip4); 336ALTER EXTENSION ip4r ADD FUNCTION ip4r_le(ip4r,ip4r); 337ALTER EXTENSION ip4r ADD FUNCTION ip6_le(ip6,ip6); 338ALTER EXTENSION ip4r ADD FUNCTION ip6r_le(ip6r,ip6r); 339ALTER EXTENSION ip4r ADD FUNCTION ipaddress_le(ipaddress,ipaddress); 340ALTER EXTENSION ip4r ADD FUNCTION iprange_le(iprange,iprange); 341ALTER EXTENSION ip4r ADD OPERATOR <=(ip4,ip4); 342ALTER EXTENSION ip4r ADD OPERATOR <=(ip4r,ip4r); 343ALTER EXTENSION ip4r ADD OPERATOR <=(ip6,ip6); 344ALTER EXTENSION ip4r ADD OPERATOR <=(ip6r,ip6r); 345ALTER EXTENSION ip4r ADD OPERATOR <=(ipaddress,ipaddress); 346ALTER EXTENSION ip4r ADD OPERATOR <=(iprange,iprange); 347ALTER EXTENSION ip4r ADD FUNCTION ip4_lt(ip4,ip4); 348ALTER EXTENSION ip4r ADD FUNCTION ip4r_lt(ip4r,ip4r); 349ALTER EXTENSION ip4r ADD FUNCTION ip6_lt(ip6,ip6); 350ALTER EXTENSION ip4r ADD FUNCTION ip6r_lt(ip6r,ip6r); 351ALTER EXTENSION ip4r ADD FUNCTION ipaddress_lt(ipaddress,ipaddress); 352ALTER EXTENSION ip4r ADD FUNCTION iprange_lt(iprange,iprange); 353ALTER EXTENSION ip4r ADD OPERATOR <(ip4,ip4); 354ALTER EXTENSION ip4r ADD OPERATOR <(ip4r,ip4r); 355ALTER EXTENSION ip4r ADD OPERATOR <(ip6,ip6); 356ALTER EXTENSION ip4r ADD OPERATOR <(ip6r,ip6r); 357ALTER EXTENSION ip4r ADD OPERATOR <(ipaddress,ipaddress); 358ALTER EXTENSION ip4r ADD OPERATOR <(iprange,iprange); 359ALTER EXTENSION ip4r ADD FUNCTION ip4_neq(ip4,ip4); 360ALTER EXTENSION ip4r ADD FUNCTION ip4r_neq(ip4r,ip4r); 361ALTER EXTENSION ip4r ADD FUNCTION ip6_neq(ip6,ip6); 362ALTER EXTENSION ip4r ADD FUNCTION ip6r_neq(ip6r,ip6r); 363ALTER EXTENSION ip4r ADD FUNCTION ipaddress_neq(ipaddress,ipaddress); 364ALTER EXTENSION ip4r ADD FUNCTION iprange_neq(iprange,iprange); 365ALTER EXTENSION ip4r ADD OPERATOR <>(ip4,ip4); 366ALTER EXTENSION ip4r ADD OPERATOR <>(ip4r,ip4r); 367ALTER EXTENSION ip4r ADD OPERATOR <>(ip6,ip6); 368ALTER EXTENSION ip4r ADD OPERATOR <>(ip6r,ip6r); 369ALTER EXTENSION ip4r ADD OPERATOR <>(ipaddress,ipaddress); 370ALTER EXTENSION ip4r ADD OPERATOR <>(iprange,iprange); 371ALTER EXTENSION ip4r ADD FUNCTION ip4_cmp(ip4,ip4); 372ALTER EXTENSION ip4r ADD FUNCTION ip4r_cmp(ip4r,ip4r); 373ALTER EXTENSION ip4r ADD FUNCTION ip6_cmp(ip6,ip6); 374ALTER EXTENSION ip4r ADD FUNCTION ip6r_cmp(ip6r,ip6r); 375ALTER EXTENSION ip4r ADD FUNCTION ipaddress_cmp(ipaddress,ipaddress); 376ALTER EXTENSION ip4r ADD FUNCTION iprange_cmp(iprange,iprange); 377ALTER EXTENSION ip4r ADD OPERATOR CLASS btree_ip4_ops USING btree; 378ALTER EXTENSION ip4r ADD OPERATOR CLASS btree_ip4r_ops USING btree; 379ALTER EXTENSION ip4r ADD OPERATOR CLASS btree_ip6_ops USING btree; 380ALTER EXTENSION ip4r ADD OPERATOR CLASS btree_ip6r_ops USING btree; 381ALTER EXTENSION ip4r ADD OPERATOR CLASS btree_ipaddress_ops USING btree; 382ALTER EXTENSION ip4r ADD OPERATOR CLASS btree_iprange_ops USING btree; 383ALTER EXTENSION ip4r ADD FUNCTION ip4hash(ip4); 384ALTER EXTENSION ip4r ADD FUNCTION ip6hash(ip6); 385ALTER EXTENSION ip4r ADD FUNCTION ipaddresshash(ipaddress); 386ALTER EXTENSION ip4r ADD FUNCTION ip4rhash(ip4r); 387ALTER EXTENSION ip4r ADD FUNCTION ip6rhash(ip6r); 388ALTER EXTENSION ip4r ADD FUNCTION iprangehash(iprange); 389ALTER EXTENSION ip4r ADD OPERATOR CLASS hash_ip4_ops USING hash; 390ALTER EXTENSION ip4r ADD OPERATOR CLASS hash_ip4r_ops USING hash; 391ALTER EXTENSION ip4r ADD OPERATOR CLASS hash_ip6_ops USING hash; 392ALTER EXTENSION ip4r ADD OPERATOR CLASS hash_ip6r_ops USING hash; 393ALTER EXTENSION ip4r ADD OPERATOR CLASS hash_ipaddress_ops USING hash; 394ALTER EXTENSION ip4r ADD OPERATOR CLASS hash_iprange_ops USING hash; 395ALTER EXTENSION ip4r ADD FUNCTION gip4r_consistent(internal,ip4r,int2,oid,internal); 396ALTER EXTENSION ip4r ADD FUNCTION gip4r_compress(internal); 397ALTER EXTENSION ip4r ADD FUNCTION gip4r_decompress(internal); 398ALTER EXTENSION ip4r ADD FUNCTION gip4r_penalty(internal,internal,internal); 399ALTER EXTENSION ip4r ADD FUNCTION gip4r_picksplit(internal, internal); 400ALTER EXTENSION ip4r ADD FUNCTION gip4r_union(internal, internal); 401ALTER EXTENSION ip4r ADD FUNCTION gip4r_same(ip4r, ip4r, internal); 402ALTER EXTENSION ip4r ADD FUNCTION gip4r_fetch(internal); 403ALTER EXTENSION ip4r ADD FUNCTION gip6r_consistent(internal,ip6r,int2,oid,internal); 404ALTER EXTENSION ip4r ADD FUNCTION gip6r_compress(internal); 405ALTER EXTENSION ip4r ADD FUNCTION gip6r_decompress(internal); 406ALTER EXTENSION ip4r ADD FUNCTION gip6r_penalty(internal,internal,internal); 407ALTER EXTENSION ip4r ADD FUNCTION gip6r_picksplit(internal, internal); 408ALTER EXTENSION ip4r ADD FUNCTION gip6r_union(internal, internal); 409ALTER EXTENSION ip4r ADD FUNCTION gip6r_same(ip6r, ip6r, internal); 410ALTER EXTENSION ip4r ADD FUNCTION gip6r_fetch(internal); 411ALTER EXTENSION ip4r ADD FUNCTION gipr_consistent(internal,iprange,int2,oid,internal); 412ALTER EXTENSION ip4r ADD FUNCTION gipr_compress(internal); 413ALTER EXTENSION ip4r ADD FUNCTION gipr_decompress(internal); 414ALTER EXTENSION ip4r ADD FUNCTION gipr_penalty(internal,internal,internal); 415ALTER EXTENSION ip4r ADD FUNCTION gipr_picksplit(internal, internal); 416ALTER EXTENSION ip4r ADD FUNCTION gipr_union(internal, internal); 417ALTER EXTENSION ip4r ADD FUNCTION gipr_same(iprange, iprange, internal); 418ALTER EXTENSION ip4r ADD FUNCTION gipr_fetch(internal); 419ALTER EXTENSION ip4r ADD OPERATOR CLASS gist_ip4r_ops USING gist; 420ALTER EXTENSION ip4r ADD OPERATOR CLASS gist_ip6r_ops USING gist; 421ALTER EXTENSION ip4r ADD OPERATOR CLASS gist_iprange_ops USING gist; 422 423-- end 424