Functions and Operators Function Return Type Description Example Result div(y numeric, x numeric) numeric integer quotient of y/x div(9,4) 2 exp(dp or numeric) (same as input) exponential exp(1.0) 2 on success and -1 in case of error. PGTYPESnumeric_div Divide two numeric variables and return the result in a third one. int PGTYPESnumeric_div(numeric *var1, numeric *var2, numeric *result); The function dates_trigger() trigger function to avoid overhead for non- data-changing updates (Andrew) • Add div(numeric, numeric) to perform numeric division without rounding (Tom) • Add timestamp and timestamptz

-95 degrees(dp) dp radians to degrees degrees(0.5) 28.6478897565412 div(y numeric, x numeric) numeric integer quotient of y/x div(9,4) 2 exp(dp or numeric) (same as input) exponential exp(1.0) 2 on success and -1 in case of error. PGTYPESnumeric_div Divide two numeric variables and return the result in a third one. int PGTYPESnumeric_div(numeric *var1, numeric *var2, numeric *result); The function dates_trigger() trigger function to avoid overhead for non-data- changing updates (Andrew) • Add div(numeric, numeric) to perform numeric division without rounding (Tom) • Add timestamp and timestamptz

-95 degrees(dp) dp radians to degrees degrees(0.5) 28.6478897565412 div(y numeric, x numeric) numeric integer quotient of y/x div(9,4) 2 exp(dp or numeric) (same as input) exponential exp(1.0) 2 on success and -1 in case of error. PGTYPESnumeric_div Divide two numeric variables and return the result in a third one. int PGTYPESnumeric_div(numeric *var1, numeric *var2, numeric *result); The function dates_trigger() trigger function to avoid overhead for non-data- changing updates (Andrew) • Add div(numeric, numeric) to perform numeric division without rounding (Tom) • Add timestamp and timestamptz

Functions and Operators Function Return Type Description Example Result div(y numeric, x numeric) numeric integer quotient of y/x div(9,4) 2 exp(dp or numeric) (same as input) exponential exp(1.0) 2 on success and -1 in case of error. PGTYPESnumeric_div Divide two numeric variables and return the result in a third one. int PGTYPESnumeric_div(numeric *var1, numeric *var2, numeric *result); The function dates_trigger() trigger function to avoid overhead for non- data-changing updates (Andrew) • Add div(numeric, numeric) to perform numeric division without rounding (Tom) • Add timestamp and timestamptz

-95 degrees(dp) dp radians to degrees degrees(0.5) 28.6478897565412 div(y numeric, x numeric) numeric integer quotient of y/x div(9,4) 2 157 Chapter 9. Functions and Operators Function Return Type on success and -1 in case of error. PGTYPESnumeric_div Divide two numeric variables and return the result in a third one. int PGTYPESnumeric_div(numeric *var1, numeric *var2, numeric *result); The function dates_trigger() trigger function to avoid overhead for non- data-changing updates (Andrew) • Add div(numeric, numeric) to perform numeric division without rounding (Tom) • Add timestamp and timestamptz

-95 degrees(dp) dp radians to degrees degrees(0.5) 28.6478897565412 div(y numeric, x numeric) numeric integer quotient of y/x div(9,4) 2 exp(dp or numeric) (same as input) exponential exp(1.0) 2 on success and -1 in case of error. PGTYPESnumeric_div Divide two numeric variables and return the result in a third one. int PGTYPESnumeric_div(numeric *var1, numeric *var2, numeric *result); The function dates_trigger() trigger function to avoid overhead for non-data- changing updates (Andrew) • Add div(numeric, numeric) to perform numeric division without rounding (Tom) • Add timestamp and timestamptz

-95 degrees(dp) dp radians to degrees degrees(0.5) 28.6478897565412 div(y numeric, x numeric) numeric integer quotient of y/x div(9,4) 2 167 Chapter 9. Functions and Operators Function Return Type on success and -1 in case of error. PGTYPESnumeric_div Divide two numeric variables and return the result in a third one. int PGTYPESnumeric_div(numeric *var1, numeric *var2, numeric *result); The function dates_trigger() trigger function to avoid overhead for non- data-changing updates (Andrew) • Add div(numeric, numeric) to perform numeric division without rounding (Tom) • Add timestamp and timestamptz

-95 degrees(dp) dp radians to degrees degrees(0.5) 28.6478897565412 div(y numeric, x numeric) numeric integer quotient of y/x div(9,4) 2 exp(dp or numeric) (same as input) exponential exp(1.0) 2 on success and -1 in case of error. PGTYPESnumeric_div Divide two numeric variables and return the result in a third one. int PGTYPESnumeric_div(numeric *var1, numeric *var2, numeric *result); The function dates_trigger() trigger function to avoid overhead for non-data- changing updates (Andrew) • Add div(numeric, numeric) to perform numeric division without rounding (Tom) • Add timestamp and timestamptz

-95 degrees(dp) dp radians to degrees degrees(0.5) 28.6478897565412 div(y numeric, x numeric) numeric integer quotient of y/x div(9,4) 2 170 Chapter 9. Functions and Operators Function Return Type on success and -1 in case of error. PGTYPESnumeric_div Divide two numeric variables and return the result in a third one. int PGTYPESnumeric_div(numeric *var1, numeric *var2, numeric *result); The function dates_trigger() trigger function to avoid overhead for non- data-changing updates (Andrew) • Add div(numeric, numeric) to perform numeric division without rounding (Tom) • Add timestamp and timestamptz

-95 degrees(dp) dp radians to degrees degrees(0.5) 28.6478897565412 div(y numeric, x numeric) numeric integer quotient of y/x div(9,4) 2 exp(dp or numeric) (same as input) exponential exp(1.0) 2 on success and -1 in case of error. PGTYPESnumeric_div Divide two numeric variables and return the result in a third one. int PGTYPESnumeric_div(numeric *var1, numeric *var2, numeric *result); The function dates_trigger() trigger function to avoid overhead for non-data- changing updates (Andrew) • Add div(numeric, numeric) to perform numeric division without rounding (Tom) • Add timestamp and timestamptz