/usr/share/postgresql/9.1/pgmp/pgmp--unpackaged--1.0.sql is in postgresql-9.1-pgmp 1.0.0-4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 | -- This file was automatically generated
-- by the script 'tools/sql2extension.py'
-- from input files: sql/pgmp--1.0.sql
ALTER EXTENSION pgmp ADD FUNCTION gmp_version ();
ALTER EXTENSION pgmp ADD FUNCTION mpz_in (cstring);
ALTER EXTENSION pgmp ADD FUNCTION mpz_out (mpz);
ALTER EXTENSION pgmp ADD TYPE mpz;
ALTER EXTENSION pgmp ADD FUNCTION mpz (text, int4);
ALTER EXTENSION pgmp ADD FUNCTION text (mpz, int4);
ALTER EXTENSION pgmp ADD FUNCTION mpz (int2);
ALTER EXTENSION pgmp ADD CAST (int2 AS mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz (int4);
ALTER EXTENSION pgmp ADD CAST (int4 AS mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz (int8);
ALTER EXTENSION pgmp ADD CAST (int8 AS mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz (float4);
ALTER EXTENSION pgmp ADD CAST (float4 AS mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz (float8);
ALTER EXTENSION pgmp ADD CAST (float8 AS mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz (numeric);
ALTER EXTENSION pgmp ADD CAST (numeric AS mpz);
ALTER EXTENSION pgmp ADD FUNCTION int8 (mpz);
ALTER EXTENSION pgmp ADD CAST (mpz AS int8);
ALTER EXTENSION pgmp ADD FUNCTION int4 (mpz);
ALTER EXTENSION pgmp ADD CAST (mpz AS int4);
ALTER EXTENSION pgmp ADD FUNCTION int2 (mpz);
ALTER EXTENSION pgmp ADD CAST (mpz AS int2);
ALTER EXTENSION pgmp ADD FUNCTION float4 (mpz);
ALTER EXTENSION pgmp ADD CAST (mpz AS float4);
ALTER EXTENSION pgmp ADD FUNCTION float8 (mpz);
ALTER EXTENSION pgmp ADD CAST (mpz AS float8);
ALTER EXTENSION pgmp ADD CAST (mpz AS numeric);
ALTER EXTENSION pgmp ADD FUNCTION mpz_uplus (mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_neg (mpz);
ALTER EXTENSION pgmp ADD FUNCTION abs (mpz);
ALTER EXTENSION pgmp ADD FUNCTION sgn (mpz);
ALTER EXTENSION pgmp ADD FUNCTION even (mpz);
ALTER EXTENSION pgmp ADD FUNCTION odd (mpz);
ALTER EXTENSION pgmp ADD OPERATOR - (NONE, mpz);
ALTER EXTENSION pgmp ADD OPERATOR + (NONE, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_add (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR + (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_sub (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR - (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_mul (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR * (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_tdiv_q (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR / (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_tdiv_r (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR % (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_cdiv_q (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR +/ (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_cdiv_r (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR +% (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_fdiv_q (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR -/ (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_fdiv_r (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR -% (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_divexact (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR /! (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_mul_2exp (mpz, int8);
ALTER EXTENSION pgmp ADD OPERATOR << (mpz, int8);
ALTER EXTENSION pgmp ADD FUNCTION mpz_tdiv_q_2exp (mpz, int8);
ALTER EXTENSION pgmp ADD OPERATOR >> (mpz, int8);
ALTER EXTENSION pgmp ADD FUNCTION mpz_tdiv_r_2exp (mpz, int8);
ALTER EXTENSION pgmp ADD OPERATOR %> (mpz, int8);
ALTER EXTENSION pgmp ADD FUNCTION mpz_cdiv_q_2exp (mpz, int8);
ALTER EXTENSION pgmp ADD OPERATOR +>> (mpz, int8);
ALTER EXTENSION pgmp ADD FUNCTION mpz_cdiv_r_2exp (mpz, int8);
ALTER EXTENSION pgmp ADD OPERATOR +%> (mpz, int8);
ALTER EXTENSION pgmp ADD FUNCTION mpz_fdiv_q_2exp (mpz, int8);
ALTER EXTENSION pgmp ADD OPERATOR ->> (mpz, int8);
ALTER EXTENSION pgmp ADD FUNCTION mpz_fdiv_r_2exp (mpz, int8);
ALTER EXTENSION pgmp ADD OPERATOR -%> (mpz, int8);
ALTER EXTENSION pgmp ADD FUNCTION tdiv_qr (mpz, mpz, out q mpz, out r mpz);
ALTER EXTENSION pgmp ADD FUNCTION cdiv_qr (mpz, mpz, out q mpz, out r mpz);
ALTER EXTENSION pgmp ADD FUNCTION fdiv_qr (mpz, mpz, out q mpz, out r mpz);
ALTER EXTENSION pgmp ADD FUNCTION divisible (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION divisible_2exp (mpz, int8);
ALTER EXTENSION pgmp ADD FUNCTION congruent (mpz, mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION congruent_2exp (mpz, mpz, int8);
ALTER EXTENSION pgmp ADD FUNCTION pow (mpz, int8);
ALTER EXTENSION pgmp ADD FUNCTION powm (mpz, mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_and (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR & (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_ior (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR | (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_xor (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR # (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION com (mpz);
ALTER EXTENSION pgmp ADD FUNCTION popcount (mpz);
ALTER EXTENSION pgmp ADD FUNCTION hamdist (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION scan0 (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION scan1 (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION setbit (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION clrbit (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION combit (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION tstbit (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION gmp_max_bitcnt ();
ALTER EXTENSION pgmp ADD OPERATOR /? (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR >>? (mpz, int8);
ALTER EXTENSION pgmp ADD OPERATOR ^ (mpz, int8);
ALTER EXTENSION pgmp ADD FUNCTION mpz_eq (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR = (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_ne (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR <> (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_gt (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR > (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_ge (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR >= (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_lt (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR < (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_le (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR <= (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpz_cmp (mpz, mpz);
ALTER EXTENSION pgmp ADD OPERATOR CLASS mpz_ops USING btree;
ALTER EXTENSION pgmp ADD FUNCTION mpz_hash (mpz);
ALTER EXTENSION pgmp ADD OPERATOR CLASS mpz_ops USING hash;
ALTER EXTENSION pgmp ADD FUNCTION sqrt (mpz);
ALTER EXTENSION pgmp ADD FUNCTION root (mpz, int8);
ALTER EXTENSION pgmp ADD FUNCTION perfect_power (mpz);
ALTER EXTENSION pgmp ADD FUNCTION perfect_square (mpz);
ALTER EXTENSION pgmp ADD FUNCTION rootrem (mpz, int8, out root mpz, out rem mpz);
ALTER EXTENSION pgmp ADD FUNCTION sqrtrem (mpz, out root mpz, out rem mpz);
ALTER EXTENSION pgmp ADD FUNCTION probab_prime (mpz, int4);
ALTER EXTENSION pgmp ADD FUNCTION nextprime (mpz);
ALTER EXTENSION pgmp ADD FUNCTION gcd (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION lcm (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION invert (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION jacobi (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION legendre (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION kronecker (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION remove (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION fac (int8);
ALTER EXTENSION pgmp ADD FUNCTION bin (mpz, int8);
ALTER EXTENSION pgmp ADD FUNCTION fib (int8);
ALTER EXTENSION pgmp ADD FUNCTION lucnum (int8);
ALTER EXTENSION pgmp ADD FUNCTION gcdext (mpz, mpz, out g mpz, out s mpz, out t mpz);
ALTER EXTENSION pgmp ADD FUNCTION fib2 (int8, out fn mpz, out fnsub1 mpz);
ALTER EXTENSION pgmp ADD FUNCTION lucnum2 (int8, out ln mpz, out lnsub1 mpz);
ALTER EXTENSION pgmp ADD FUNCTION randinit ();
ALTER EXTENSION pgmp ADD FUNCTION randinit_mt ();
ALTER EXTENSION pgmp ADD FUNCTION randinit_lc_2exp (mpz, int8, int8);
ALTER EXTENSION pgmp ADD FUNCTION randinit_lc_2exp_size (int8);
ALTER EXTENSION pgmp ADD FUNCTION randseed (mpz);
ALTER EXTENSION pgmp ADD FUNCTION urandomb (int8);
ALTER EXTENSION pgmp ADD FUNCTION urandomm (mpz);
ALTER EXTENSION pgmp ADD FUNCTION rrandomb (int8);
ALTER EXTENSION pgmp ADD FUNCTION _mpz_from_agg (internal);
ALTER EXTENSION pgmp ADD FUNCTION _mpz_agg_add (internal, mpz);
ALTER EXTENSION pgmp ADD AGGREGATE sum (mpz);
ALTER EXTENSION pgmp ADD FUNCTION _mpz_agg_mul (internal, mpz);
ALTER EXTENSION pgmp ADD AGGREGATE prod (mpz);
ALTER EXTENSION pgmp ADD FUNCTION _mpz_agg_max (internal, mpz);
ALTER EXTENSION pgmp ADD AGGREGATE max (mpz);
ALTER EXTENSION pgmp ADD FUNCTION _mpz_agg_min (internal, mpz);
ALTER EXTENSION pgmp ADD AGGREGATE min (mpz);
ALTER EXTENSION pgmp ADD FUNCTION _mpz_agg_and (internal, mpz);
ALTER EXTENSION pgmp ADD AGGREGATE bit_and (mpz);
ALTER EXTENSION pgmp ADD FUNCTION _mpz_agg_ior (internal, mpz);
ALTER EXTENSION pgmp ADD AGGREGATE bit_or (mpz);
ALTER EXTENSION pgmp ADD FUNCTION _mpz_agg_xor (internal, mpz);
ALTER EXTENSION pgmp ADD AGGREGATE bit_xor (mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpq_in (cstring);
ALTER EXTENSION pgmp ADD FUNCTION mpq_out (mpq);
ALTER EXTENSION pgmp ADD TYPE mpq;
ALTER EXTENSION pgmp ADD FUNCTION mpq (text, int4);
ALTER EXTENSION pgmp ADD FUNCTION text (mpq, int4);
ALTER EXTENSION pgmp ADD FUNCTION mpq (mpz, mpz);
ALTER EXTENSION pgmp ADD FUNCTION num (mpq);
ALTER EXTENSION pgmp ADD FUNCTION den (mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq (int2);
ALTER EXTENSION pgmp ADD CAST (int2 AS mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq (int4);
ALTER EXTENSION pgmp ADD CAST (int4 AS mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq (int8);
ALTER EXTENSION pgmp ADD CAST (int8 AS mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq (float4);
ALTER EXTENSION pgmp ADD CAST (float4 AS mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq (float8);
ALTER EXTENSION pgmp ADD CAST (float8 AS mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq (numeric);
ALTER EXTENSION pgmp ADD CAST (numeric AS mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq (mpz);
ALTER EXTENSION pgmp ADD CAST (mpz AS mpq);
ALTER EXTENSION pgmp ADD FUNCTION int2 (mpq);
ALTER EXTENSION pgmp ADD CAST (mpq AS int2);
ALTER EXTENSION pgmp ADD FUNCTION int4 (mpq);
ALTER EXTENSION pgmp ADD CAST (mpq AS int4);
ALTER EXTENSION pgmp ADD FUNCTION int8 (mpq);
ALTER EXTENSION pgmp ADD CAST (mpq AS int8);
ALTER EXTENSION pgmp ADD FUNCTION float4 (mpq);
ALTER EXTENSION pgmp ADD CAST (mpq AS float4);
ALTER EXTENSION pgmp ADD FUNCTION float8 (mpq);
ALTER EXTENSION pgmp ADD CAST (mpq AS float8);
ALTER EXTENSION pgmp ADD FUNCTION mpz (mpq);
ALTER EXTENSION pgmp ADD CAST (mpq AS mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpq_to_numeric (mpq, int4);
ALTER EXTENSION pgmp ADD CAST (mpq AS numeric);
ALTER EXTENSION pgmp ADD FUNCTION mpq_uplus (mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq_neg (mpq);
ALTER EXTENSION pgmp ADD FUNCTION abs (mpq);
ALTER EXTENSION pgmp ADD FUNCTION inv (mpq);
ALTER EXTENSION pgmp ADD OPERATOR - (NONE, mpq);
ALTER EXTENSION pgmp ADD OPERATOR + (NONE, mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq_add (mpq, mpq);
ALTER EXTENSION pgmp ADD OPERATOR + (mpq, mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq_sub (mpq, mpq);
ALTER EXTENSION pgmp ADD OPERATOR - (mpq, mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq_mul (mpq, mpq);
ALTER EXTENSION pgmp ADD OPERATOR * (mpq, mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq_div (mpq, mpq);
ALTER EXTENSION pgmp ADD OPERATOR / (mpq, mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq_mul_2exp (mpq, int8);
ALTER EXTENSION pgmp ADD OPERATOR << (mpq, int8);
ALTER EXTENSION pgmp ADD FUNCTION mpq_div_2exp (mpq, int8);
ALTER EXTENSION pgmp ADD OPERATOR >> (mpq, int8);
ALTER EXTENSION pgmp ADD FUNCTION limit_den (mpq);
ALTER EXTENSION pgmp ADD FUNCTION limit_den (mpq, mpz);
ALTER EXTENSION pgmp ADD FUNCTION mpq_eq (mpq, mpq);
ALTER EXTENSION pgmp ADD OPERATOR = (mpq, mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq_ne (mpq, mpq);
ALTER EXTENSION pgmp ADD OPERATOR <> (mpq, mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq_gt (mpq, mpq);
ALTER EXTENSION pgmp ADD OPERATOR > (mpq, mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq_ge (mpq, mpq);
ALTER EXTENSION pgmp ADD OPERATOR >= (mpq, mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq_lt (mpq, mpq);
ALTER EXTENSION pgmp ADD OPERATOR < (mpq, mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq_le (mpq, mpq);
ALTER EXTENSION pgmp ADD OPERATOR <= (mpq, mpq);
ALTER EXTENSION pgmp ADD FUNCTION mpq_cmp (mpq, mpq);
ALTER EXTENSION pgmp ADD OPERATOR CLASS mpq_ops USING btree;
ALTER EXTENSION pgmp ADD FUNCTION mpq_hash (mpq);
ALTER EXTENSION pgmp ADD OPERATOR CLASS mpq_ops USING hash;
ALTER EXTENSION pgmp ADD FUNCTION _mpq_from_agg (internal);
ALTER EXTENSION pgmp ADD FUNCTION _mpq_agg_add (internal, mpq);
ALTER EXTENSION pgmp ADD AGGREGATE sum (mpq);
ALTER EXTENSION pgmp ADD FUNCTION _mpq_agg_mul (internal, mpq);
ALTER EXTENSION pgmp ADD AGGREGATE prod (mpq);
ALTER EXTENSION pgmp ADD FUNCTION _mpq_agg_max (internal, mpq);
ALTER EXTENSION pgmp ADD AGGREGATE max (mpq);
ALTER EXTENSION pgmp ADD FUNCTION _mpq_agg_min (internal, mpq);
ALTER EXTENSION pgmp ADD AGGREGATE min (mpq);
|