 |
MobilityDB 1.3
|
|
MobilityDB 1.3
|
Functions for base and time types. More...
Functions | |
| DateADT | add_date_int (DateADT d, int32 days) |
| Return the addition of a date and a number of days. More... | |
| Interval * | add_interval_interval (const Interval *interv1, const Interval *interv2) |
| Return the addition of two intervals. More... | |
| TimestampTz | add_timestamptz_interval (TimestampTz t, const Interval *interv) |
| Return the addition of a timestamp and an interval. More... | |
| bool | bool_in (const char *str) |
| Return a boolean from its string representation. More... | |
| char * | bool_out (bool b) |
| Return the string representation of a boolean. More... | |
| text * | cstring2text (const char *str) |
| Convert a C string into a text. More... | |
| DateADT | date_in (const char *str) |
| Return a date from its string representation. More... | |
| char * | date_out (DateADT d) |
| Return the string representation of a date. More... | |
| Timestamp | date_to_timestamp (DateADT d) |
| Convert a date into a timestamp. More... | |
| TimestampTz | date_to_timestamptz (DateADT d) |
| Convert a date into a timestamptz. More... | |
| double | float_exp (double d) |
| Return the exponential of a double. More... | |
| double | float_ln (double d) |
| Return the natural logarithm of a double. More... | |
| double | float_log10 (double d) |
| Return the logarithm base 10 of a double. More... | |
| double | float_round (double d, int maxdd) |
| Return a float number rounded to a given number of decimal places. More... | |
| int | interval_cmp (const Interval *interv1, const Interval *interv2) |
| Return the comparison of two intervals. More... | |
| Interval * | interval_in (const char *str, int32 prec) |
| Return an interval from its string representation. More... | |
| Interval * | interval_make (int32 years, int32 months, int32 weeks, int32 days, int32 hours, int32 mins, double secs) |
| Return an interval constructed from its arguments. More... | |
| char * | interval_out (const Interval *interv) |
| Return the string representation of an interval. More... | |
| Interval * | minus_date_date (DateADT d1, DateADT d2) |
| Return the subtraction of two dates. More... | |
| DateADT | minus_date_int (DateADT d, int32 days) |
| Return the subtraction of a date and a number of days. More... | |
| TimestampTz | minus_timestamptz_interval (TimestampTz t, const Interval *interv) |
| Return the subtraction of a timestamptz and an interval. More... | |
| Interval * | minus_timestamptz_timestamptz (TimestampTz t1, TimestampTz t2) |
| Return the subtraction of two timestamptz values. More... | |
| Interval * | mul_interval_double (const Interval *interv, double factor) |
| Return the multiplication of an interval and a factor. More... | |
| char * | text2cstring (const text *txt) |
| Convert a text into a C string. More... | |
| int | text_cmp (const text *txt1, const text *txt2) |
| Comparison function for text values. More... | |
| text * | text_copy (const text *txt) |
| Copy a text value. More... | |
| text * | text_initcap (const text *txt) |
| Convert the text value to initcap. More... | |
| text * | text_lower (const text *txt) |
| Return the text value transformed to lowercase. More... | |
| char * | text_out (const text *txt) |
| Return the string representation of a text value. More... | |
| text * | text_upper (const text *txt) |
| Return the text value transformed to uppercase. More... | |
| text * | textcat_text_text (const text *txt1, const text *txt2) |
| Return the concatenation of the two text values. More... | |
| TimeADT | time_in (const char *str, int32 prec) |
| Return a time from its string representation. More... | |
| char * | time_out (TimeADT t) |
| Return the string representation of a time. More... | |
| Timestamp | timestamp_in (const char *str, int32 prec) |
| Return a timestamp without time zone from its string representation. More... | |
| char * | timestamp_out (Timestamp t) |
| Return the string representation of a timestamp without timezone. More... | |
| DateADT | timestamp_to_date (Timestamp t) |
| Convert a timestamp into a date. More... | |
| TimestampTz | timestamptz_in (const char *str, int32 prec) |
| Return the string representation of a timestamp with time zone. More... | |
| char * | timestamptz_out (TimestampTz t) |
| Return the string representation of a timestamp with timezone. More... | |
| TimestampTz | timestamptz_shift (TimestampTz t, const Interval *interv) |
| Return a timestamptz shifted by an interval. More... | |
| DateADT | timestamptz_to_date (TimestampTz t) |
| Convert a timestamp with time zone into a date. More... | |
Functions for base and time types.
1.9.5