MobilityDB 1.1
Functions
Functions for PostgreSQL types

Functions for PostgreSQL types. More...

Collaboration diagram for Functions for PostgreSQL types:

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...
 
Intervalpg_interval_in (const char *str, int32 typmod)
 Convert a string to an interval. More...
 
Intervalpg_interval_make (int32 years, int32 months, int32 weeks, int32 days, int32 hours, int32 mins, double secs)
 Interval constructor. More...
 
Intervalpg_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...
 
Intervalpg_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...
 
Intervalpg_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...
 

Detailed Description

Functions for PostgreSQL types.