Referencia del Archivo src/libpq/include/utils/date.h

#include "fmgr.h"

Ir al código fuente de este archivo.

Clases
struct	TimeTzADT
'defines'
#define	MAX_TIME_PRECISION   10
#define	TIME_PREC_INV   10000000000.0
#define	TIMEROUND(j)   (rint(((double) (j)) * TIME_PREC_INV) / TIME_PREC_INV)
#define	DatumGetDateADT(X)   ((DateADT) DatumGetInt32(X))
#define	DatumGetTimeADT(X)   ((TimeADT) DatumGetFloat8(X))
#define	DatumGetTimeTzADTP(X)   ((TimeTzADT *) DatumGetPointer(X))
#define	DateADTGetDatum(X)   Int32GetDatum(X)
#define	TimeADTGetDatum(X)   Float8GetDatum(X)
#define	TimeTzADTPGetDatum(X)   PointerGetDatum(X)
#define	PG_GETARG_DATEADT(n)   DatumGetDateADT(PG_GETARG_DATUM(n))
#define	PG_GETARG_TIMEADT(n)   DatumGetTimeADT(PG_GETARG_DATUM(n))
#define	PG_GETARG_TIMETZADT_P(n)   DatumGetTimeTzADTP(PG_GETARG_DATUM(n))
#define	PG_RETURN_DATEADT(x)   return DateADTGetDatum(x)
#define	PG_RETURN_TIMEADT(x)   return TimeADTGetDatum(x)
#define	PG_RETURN_TIMETZADT_P(x)   return TimeTzADTPGetDatum(x)
'typedefs'
typedef int32	DateADT
typedef float8	TimeADT
Funciones
Datum	date_in (PG_FUNCTION_ARGS)
Datum	date_out (PG_FUNCTION_ARGS)
Datum	date_recv (PG_FUNCTION_ARGS)
Datum	date_send (PG_FUNCTION_ARGS)
Datum	date_eq (PG_FUNCTION_ARGS)
Datum	date_ne (PG_FUNCTION_ARGS)
Datum	date_lt (PG_FUNCTION_ARGS)
Datum	date_le (PG_FUNCTION_ARGS)
Datum	date_gt (PG_FUNCTION_ARGS)
Datum	date_ge (PG_FUNCTION_ARGS)
Datum	date_cmp (PG_FUNCTION_ARGS)
Datum	date_larger (PG_FUNCTION_ARGS)
Datum	date_smaller (PG_FUNCTION_ARGS)
Datum	date_mi (PG_FUNCTION_ARGS)
Datum	date_pli (PG_FUNCTION_ARGS)
Datum	date_mii (PG_FUNCTION_ARGS)
Datum	date_eq_timestamp (PG_FUNCTION_ARGS)
Datum	date_ne_timestamp (PG_FUNCTION_ARGS)
Datum	date_lt_timestamp (PG_FUNCTION_ARGS)
Datum	date_le_timestamp (PG_FUNCTION_ARGS)
Datum	date_gt_timestamp (PG_FUNCTION_ARGS)
Datum	date_ge_timestamp (PG_FUNCTION_ARGS)
Datum	date_cmp_timestamp (PG_FUNCTION_ARGS)
Datum	date_eq_timestamptz (PG_FUNCTION_ARGS)
Datum	date_ne_timestamptz (PG_FUNCTION_ARGS)
Datum	date_lt_timestamptz (PG_FUNCTION_ARGS)
Datum	date_le_timestamptz (PG_FUNCTION_ARGS)
Datum	date_gt_timestamptz (PG_FUNCTION_ARGS)
Datum	date_ge_timestamptz (PG_FUNCTION_ARGS)
Datum	date_cmp_timestamptz (PG_FUNCTION_ARGS)
Datum	timestamp_eq_date (PG_FUNCTION_ARGS)
Datum	timestamp_ne_date (PG_FUNCTION_ARGS)
Datum	timestamp_lt_date (PG_FUNCTION_ARGS)
Datum	timestamp_le_date (PG_FUNCTION_ARGS)
Datum	timestamp_gt_date (PG_FUNCTION_ARGS)
Datum	timestamp_ge_date (PG_FUNCTION_ARGS)
Datum	timestamp_cmp_date (PG_FUNCTION_ARGS)
Datum	timestamptz_eq_date (PG_FUNCTION_ARGS)
Datum	timestamptz_ne_date (PG_FUNCTION_ARGS)
Datum	timestamptz_lt_date (PG_FUNCTION_ARGS)
Datum	timestamptz_le_date (PG_FUNCTION_ARGS)
Datum	timestamptz_gt_date (PG_FUNCTION_ARGS)
Datum	timestamptz_ge_date (PG_FUNCTION_ARGS)
Datum	timestamptz_cmp_date (PG_FUNCTION_ARGS)
Datum	date_pl_interval (PG_FUNCTION_ARGS)
Datum	date_mi_interval (PG_FUNCTION_ARGS)
Datum	date_timestamp (PG_FUNCTION_ARGS)
Datum	timestamp_date (PG_FUNCTION_ARGS)
Datum	date_timestamptz (PG_FUNCTION_ARGS)
Datum	timestamptz_date (PG_FUNCTION_ARGS)
Datum	datetime_timestamp (PG_FUNCTION_ARGS)
Datum	abstime_date (PG_FUNCTION_ARGS)
Datum	text_date (PG_FUNCTION_ARGS)
Datum	date_text (PG_FUNCTION_ARGS)
Datum	time_in (PG_FUNCTION_ARGS)
Datum	time_out (PG_FUNCTION_ARGS)
Datum	time_recv (PG_FUNCTION_ARGS)
Datum	time_send (PG_FUNCTION_ARGS)
Datum	time_scale (PG_FUNCTION_ARGS)
Datum	time_eq (PG_FUNCTION_ARGS)
Datum	time_ne (PG_FUNCTION_ARGS)
Datum	time_lt (PG_FUNCTION_ARGS)
Datum	time_le (PG_FUNCTION_ARGS)
Datum	time_gt (PG_FUNCTION_ARGS)
Datum	time_ge (PG_FUNCTION_ARGS)
Datum	time_cmp (PG_FUNCTION_ARGS)
Datum	overlaps_time (PG_FUNCTION_ARGS)
Datum	time_larger (PG_FUNCTION_ARGS)
Datum	time_smaller (PG_FUNCTION_ARGS)
Datum	time_mi_time (PG_FUNCTION_ARGS)
Datum	timestamp_time (PG_FUNCTION_ARGS)
Datum	timestamptz_time (PG_FUNCTION_ARGS)
Datum	time_interval (PG_FUNCTION_ARGS)
Datum	interval_time (PG_FUNCTION_ARGS)
Datum	text_time (PG_FUNCTION_ARGS)
Datum	time_text (PG_FUNCTION_ARGS)
Datum	time_pl_interval (PG_FUNCTION_ARGS)
Datum	time_mi_interval (PG_FUNCTION_ARGS)
Datum	time_part (PG_FUNCTION_ARGS)
Datum	timetz_in (PG_FUNCTION_ARGS)
Datum	timetz_out (PG_FUNCTION_ARGS)
Datum	timetz_recv (PG_FUNCTION_ARGS)
Datum	timetz_send (PG_FUNCTION_ARGS)
Datum	timetz_scale (PG_FUNCTION_ARGS)
Datum	timetz_eq (PG_FUNCTION_ARGS)
Datum	timetz_ne (PG_FUNCTION_ARGS)
Datum	timetz_lt (PG_FUNCTION_ARGS)
Datum	timetz_le (PG_FUNCTION_ARGS)
Datum	timetz_gt (PG_FUNCTION_ARGS)
Datum	timetz_ge (PG_FUNCTION_ARGS)
Datum	timetz_cmp (PG_FUNCTION_ARGS)
Datum	timetz_hash (PG_FUNCTION_ARGS)
Datum	overlaps_timetz (PG_FUNCTION_ARGS)
Datum	timetz_larger (PG_FUNCTION_ARGS)
Datum	timetz_smaller (PG_FUNCTION_ARGS)
Datum	timetz_time (PG_FUNCTION_ARGS)
Datum	time_timetz (PG_FUNCTION_ARGS)
Datum	timestamptz_timetz (PG_FUNCTION_ARGS)
Datum	datetimetz_timestamptz (PG_FUNCTION_ARGS)
Datum	text_timetz (PG_FUNCTION_ARGS)
Datum	timetz_text (PG_FUNCTION_ARGS)
Datum	timetz_part (PG_FUNCTION_ARGS)
Datum	timetz_zone (PG_FUNCTION_ARGS)
Datum	timetz_izone (PG_FUNCTION_ARGS)
Datum	timetz_pl_interval (PG_FUNCTION_ARGS)
Datum	timetz_mi_interval (PG_FUNCTION_ARGS)

---

Documentación de los 'defines'

#define DateADTGetDatum

(

X

)

Int32GetDatum(X)

#define DatumGetDateADT

(

X

)

((DateADT) DatumGetInt32(X))

#define DatumGetTimeADT

(

X

)

((TimeADT) DatumGetFloat8(X))

#define DatumGetTimeTzADTP

(

X

)

((TimeTzADT *) DatumGetPointer(X))

#define MAX_TIME_PRECISION   10

#define PG_GETARG_DATEADT

(

n

)

DatumGetDateADT(PG_GETARG_DATUM(n))

#define PG_GETARG_TIMEADT

(

n

)

DatumGetTimeADT(PG_GETARG_DATUM(n))

#define PG_GETARG_TIMETZADT_P

(

n

)

DatumGetTimeTzADTP(PG_GETARG_DATUM(n))

#define PG_RETURN_DATEADT

(

x

)

return DateADTGetDatum(x)

#define PG_RETURN_TIMEADT

(

x

)

return TimeADTGetDatum(x)

#define PG_RETURN_TIMETZADT_P

(

x

)

return TimeTzADTPGetDatum(x)

#define TIME_PREC_INV   10000000000.0

#define TimeADTGetDatum

(

X

)

Float8GetDatum(X)

#define TIMEROUND

(

j

)

(rint(((double) (j)) * TIME_PREC_INV) / TIME_PREC_INV)

#define TimeTzADTPGetDatum

(

X

)

PointerGetDatum(X)

---

Documentación de los 'typedefs'

typedef int32 DateADT

typedef float8 TimeADT

---

Documentación de las funciones

Datum abstime_date

(

PG_FUNCTION_ARGS

)

Datum date_cmp

(

PG_FUNCTION_ARGS

)

Datum date_cmp_timestamp

(

PG_FUNCTION_ARGS

)

Datum date_cmp_timestamptz

(

PG_FUNCTION_ARGS

)

Datum date_eq

(

PG_FUNCTION_ARGS

)

Datum date_eq_timestamp

(

PG_FUNCTION_ARGS

)

Datum date_eq_timestamptz

(

PG_FUNCTION_ARGS

)

Datum date_ge

(

PG_FUNCTION_ARGS

)

Datum date_ge_timestamp

(

PG_FUNCTION_ARGS

)

Datum date_ge_timestamptz

(

PG_FUNCTION_ARGS

)

Datum date_gt

(

PG_FUNCTION_ARGS

)

Datum date_gt_timestamp

(

PG_FUNCTION_ARGS

)

Datum date_gt_timestamptz

(

PG_FUNCTION_ARGS

)

Datum date_in

(

PG_FUNCTION_ARGS

)

Datum date_larger

(

PG_FUNCTION_ARGS

)

Datum date_le

(

PG_FUNCTION_ARGS

)

Datum date_le_timestamp

(

PG_FUNCTION_ARGS

)

Datum date_le_timestamptz

(

PG_FUNCTION_ARGS

)

Datum date_lt

(

PG_FUNCTION_ARGS

)

Datum date_lt_timestamp

(

PG_FUNCTION_ARGS

)

Datum date_lt_timestamptz

(

PG_FUNCTION_ARGS

)

Datum date_mi

(

PG_FUNCTION_ARGS

)

Datum date_mi_interval

(

PG_FUNCTION_ARGS

)

Datum date_mii

(

PG_FUNCTION_ARGS

)

Datum date_ne

(

PG_FUNCTION_ARGS

)

Datum date_ne_timestamp

(

PG_FUNCTION_ARGS

)

Datum date_ne_timestamptz

(

PG_FUNCTION_ARGS

)

Datum date_out

(

PG_FUNCTION_ARGS

)

Datum date_pl_interval

(

PG_FUNCTION_ARGS

)

Datum date_pli

(

PG_FUNCTION_ARGS

)

Datum date_recv

(

PG_FUNCTION_ARGS

)

Datum date_send

(

PG_FUNCTION_ARGS

)

Datum date_smaller

(

PG_FUNCTION_ARGS

)

Datum date_text

(

PG_FUNCTION_ARGS

)

Datum date_timestamp

(

PG_FUNCTION_ARGS

)

Datum date_timestamptz

(

PG_FUNCTION_ARGS

)

Datum datetime_timestamp

(

PG_FUNCTION_ARGS

)

Datum datetimetz_timestamptz

(

PG_FUNCTION_ARGS

)

Datum interval_time

(

PG_FUNCTION_ARGS

)

Datum overlaps_time

(

PG_FUNCTION_ARGS

)

Datum overlaps_timetz

(

PG_FUNCTION_ARGS

)

Datum text_date

(

PG_FUNCTION_ARGS

)

Datum text_time

(

PG_FUNCTION_ARGS

)

Datum text_timetz

(

PG_FUNCTION_ARGS

)

Datum time_cmp

(

PG_FUNCTION_ARGS

)

Datum time_eq

(

PG_FUNCTION_ARGS

)

Datum time_ge

(

PG_FUNCTION_ARGS

)

Datum time_gt

(

PG_FUNCTION_ARGS

)

Datum time_in

(

PG_FUNCTION_ARGS

)

Datum time_interval

(

PG_FUNCTION_ARGS

)

Datum time_larger

(

PG_FUNCTION_ARGS

)

Datum time_le

(

PG_FUNCTION_ARGS

)

Datum time_lt

(

PG_FUNCTION_ARGS

)

Datum time_mi_interval

(

PG_FUNCTION_ARGS

)

Datum time_mi_time

(

PG_FUNCTION_ARGS

)

Datum time_ne

(

PG_FUNCTION_ARGS

)

Datum time_out

(

PG_FUNCTION_ARGS

)

Datum time_part

(

PG_FUNCTION_ARGS

)

Datum time_pl_interval

(

PG_FUNCTION_ARGS

)

Datum time_recv

(

PG_FUNCTION_ARGS

)

Datum time_scale

(

PG_FUNCTION_ARGS

)

Datum time_send

(

PG_FUNCTION_ARGS

)

Datum time_smaller

(

PG_FUNCTION_ARGS

)

Datum time_text

(

PG_FUNCTION_ARGS

)

Datum time_timetz

(

PG_FUNCTION_ARGS

)

Datum timestamp_cmp_date

(

PG_FUNCTION_ARGS

)

Datum timestamp_date

(

PG_FUNCTION_ARGS

)

Datum timestamp_eq_date

(

PG_FUNCTION_ARGS

)

Datum timestamp_ge_date

(

PG_FUNCTION_ARGS

)

Datum timestamp_gt_date

(

PG_FUNCTION_ARGS

)

Datum timestamp_le_date

(

PG_FUNCTION_ARGS

)

Datum timestamp_lt_date

(

PG_FUNCTION_ARGS

)

Datum timestamp_ne_date

(

PG_FUNCTION_ARGS

)

Datum timestamp_time

(

PG_FUNCTION_ARGS

)

Datum timestamptz_cmp_date

(

PG_FUNCTION_ARGS

)

Datum timestamptz_date

(

PG_FUNCTION_ARGS

)

Datum timestamptz_eq_date

(

PG_FUNCTION_ARGS

)

Datum timestamptz_ge_date

(

PG_FUNCTION_ARGS

)

Datum timestamptz_gt_date

(

PG_FUNCTION_ARGS

)

Datum timestamptz_le_date

(

PG_FUNCTION_ARGS

)

Datum timestamptz_lt_date

(

PG_FUNCTION_ARGS

)

Datum timestamptz_ne_date

(

PG_FUNCTION_ARGS

)

Datum timestamptz_time

(

PG_FUNCTION_ARGS

)

Datum timestamptz_timetz

(

PG_FUNCTION_ARGS

)

Datum timetz_cmp

(

PG_FUNCTION_ARGS

)

Datum timetz_eq

(

PG_FUNCTION_ARGS

)

Datum timetz_ge

(

PG_FUNCTION_ARGS

)

Datum timetz_gt

(

PG_FUNCTION_ARGS

)

Datum timetz_hash

(

PG_FUNCTION_ARGS

)

Datum timetz_in

(

PG_FUNCTION_ARGS

)

Datum timetz_izone

(

PG_FUNCTION_ARGS

)

Datum timetz_larger

(

PG_FUNCTION_ARGS

)

Datum timetz_le

(

PG_FUNCTION_ARGS

)

Datum timetz_lt

(

PG_FUNCTION_ARGS

)

Datum timetz_mi_interval

(

PG_FUNCTION_ARGS

)

Datum timetz_ne

(

PG_FUNCTION_ARGS

)

Datum timetz_out

(

PG_FUNCTION_ARGS

)

Datum timetz_part

(

PG_FUNCTION_ARGS

)

Datum timetz_pl_interval

(

PG_FUNCTION_ARGS

)

Datum timetz_recv

(

PG_FUNCTION_ARGS

)

Datum timetz_scale

(

PG_FUNCTION_ARGS

)

Datum timetz_send

(

PG_FUNCTION_ARGS

)

Datum timetz_smaller

(

PG_FUNCTION_ARGS

)

Datum timetz_text

(

PG_FUNCTION_ARGS

)

Datum timetz_time

(

PG_FUNCTION_ARGS

)

Datum timetz_zone

(

PG_FUNCTION_ARGS

)