• B
    As mentioned above, here is my contrib/tablefunc patch. It includes · 41f862ba
    Bruce Momjian 提交于
    three functions which exercise the tablefunc API.
    
    show_all_settings()
       - returns the same information as SHOW ALL, but as a query result
    
    normal_rand(int numvals, float8 mean, float8 stddev, int seed)
       - returns a set of normally distributed float8 values
       - This routine implements Algorithm P (Polar method for normal
         deviates) from Knuth's _The_Art_of_Computer_Programming_, Volume 2,
         3rd ed., pages 122-126. Knuth cites his source as "The polar
         method", G. E. P. Box, M. E. Muller, and G. Marsaglia,
         _Annals_Math,_Stat._ 29 (1958), 610-611.
    
    crosstabN(text sql)
       - returns a set of row_name plus N category value columns
       - crosstab2(), crosstab3(), and crosstab4() are defined for you,
         but you can create additional crosstab functions per directions
         in the README.
    
    Joe Conway
    41f862ba
README 5.4 KB