MADlib
1.0 A newer version is available
User Documentation
|
SQL functions for carrying out routine tasks. More...
Go to the source code of this file.
Functions | |
text | version () |
Return MADlib build information. More... | |
void | assert (boolean condition, varchar msg) |
Raise an exception if the given condition is not satisfied. | |
float8 | relative_error (float8 approx, float8 value) |
Compute the relative error of an approximate value. | |
float8 | relative_error (float8[] approx, float8[] value) |
Compute the relative error (w.r.t. the 2-norm) of an apprixmate vector. | |
boolean | check_if_raises_error (text sql) |
Check if a SQL statement raises an error. More... | |
boolean | check_if_col_exists (text source_table, text column_name) |
Check if a column exists in a table. More... | |
boolean | isnan (float8 number) |
Check if a floating-point number is NaN (not a number) More... | |
void | create_schema_pg_temp () |
Create the temporary schema if it does not exist yet. | |
void | noop () |
Create volatile noop function. More... | |
CREATE OR REPLACE FUNCTION MADlib | __internal_get_col_names_except_dep_variable (source_table VARCHAR--name of input table, dependent_varname VARCHAR--name of dependent variable) RETURNS VARCHAR AS $$DECLARE col_names VARCHAR[] |
Get all column names except dependent variable. | |
Definition in file utilities.sql_in.
boolean check_if_col_exists | ( | text | source_table, |
text | column_name | ||
) |
source_table | Source table |
column_name | Column name in the table |
TRUE
if it exsists and FALSE if not Definition at line 155 of file utilities.sql_in.
boolean check_if_raises_error | ( | text | sql) |
sql | The SQL statement |
TRUE
if an exception is raised while executing sql
, FALSE
otherwise. Definition at line 132 of file utilities.sql_in.
boolean isnan | ( | float8 | number) |
This function exists for portability. Some DBMSs like PostgreSQL treat floating-point numbers as fully ordered – contrary to IEEE 754. (See, e.g., the PostgreSQL documentation. For portability, MADlib code should not make use of such "features" directly, but only use isnan() instead.
number |
TRUE
if number
is NaN
, FALSE
otherwise Definition at line 198 of file utilities.sql_in.
void noop | ( | ) |
The only use of this function is as an optimization fence when used in the SELECT list of a query. See, e.g., http://archives.postgresql.org/pgsql-sql/2012-07/msg00030.php
Definition at line 237 of file utilities.sql_in.
text version | ( | ) |
Definition at line 64 of file utilities.sql_in.