MobilityDB 1.1
|
Functions for PostgreSQL types. More...
Functions | |
bool | bool_in (const char *in_str) |
Convert "t" or "f" to 1 or 0. More... | |
char * | bool_out (bool b) |
Convert 1 or 0 to "t" or "f". More... | |
DateADT | pg_date_in (const char *str) |
Convert a string to a date in internal date format. More... | |
char * | pg_date_out (DateADT date) |
Convert a date in internal date format to a string. More... | |
int | pg_interval_cmp (const Interval *interval1, const Interval *interval2) |
Compare the two intervals. More... | |
Interval * | pg_interval_in (const char *str, int32 typmod) |
Convert a string to an interval. More... | |
Interval * | pg_interval_make (int32 years, int32 months, int32 weeks, int32 days, int32 hours, int32 mins, double secs) |
Interval constructor. More... | |
Interval * | pg_interval_mul (const Interval *span, double factor) |
Multiply an interval by a scalar. More... | |
char * | pg_interval_out (const Interval *span) |
Convert a time span to external form. More... | |
Interval * | pg_interval_pl (const Interval *span1, const Interval *span2) |
Add an interval to a timestamp data type. More... | |
TimeADT | pg_time_in (const char *str, int32 typmod) |
Convert a string to a time. More... | |
char * | pg_time_out (TimeADT time) |
Convert a time to a string. More... | |
Timestamp | pg_timestamp_in (const char *str, int32 typmod) |
Convert a string to a timestamp without time zone. More... | |
Interval * | pg_timestamp_mi (TimestampTz dt1, TimestampTz dt2) |
Compute the difference of two timestamps. More... | |
TimestampTz | pg_timestamp_mi_interval (TimestampTz timestamp, const Interval *span) |
Add an interval to a timestamp data type. More... | |
char * | pg_timestamp_out (Timestamp dt) |
Convert a timestamp without timezone to a string. More... | |
TimestampTz | pg_timestamp_pl_interval (TimestampTz timestamp, const Interval *span) |
Add an interval to a timestamp data type. More... | |
TimestampTz | pg_timestamptz_in (const char *str, int32 typmod) |
Convert a string to a timestamp with time zone. More... | |
char * | pg_timestamptz_out (TimestampTz dt) |
Convert a timestamp with timezone to a string. More... | |
Functions for PostgreSQL types.