Home Esplora Aiuto
Registrati Accedi
OTH
/
repos_util
3
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Albero (Tree): 928cff60fe
Rami (Branch) Tag
repos_util
/
libpq_test
/
include
/
server
/
utils
/
date.h

date.h 7.8 KB
Cronologia Originale

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208 
  1. /*-------------------------------------------------------------------------
    2. 

  2.  *
    3. 

  3.  * date.h
    4. 

  4.  *	  Definitions for the SQL "date" and "time" types.
    5. 

  5.  *
    6. 

  6.  *
    7. 

  7.  * Portions Copyright (c) 1996-2016, PostgreSQL Global Development Group
    8. 

  8.  * Portions Copyright (c) 1994, Regents of the University of California
    9. 

  9.  *
    10. 

  10.  * src/include/utils/date.h
    11. 

  11.  *
    12. 

  12.  *-------------------------------------------------------------------------
    13. 

  13.  */
    14. 

  14. #ifndef DATE_H
    15. 

  15. #define DATE_H
    16. 

  16. 

  17. #include <math.h>
    18. 

  18. 

  19. #include "fmgr.h"
    20. 

  20. 

  21. 

  22. typedef int32 DateADT;
    23. 

  23. 

  24. #ifdef HAVE_INT64_TIMESTAMP
    25. 

  25. typedef int64 TimeADT;
    26. 

  26. #else
    27. 

  27. typedef float8 TimeADT;
    28. 

  28. #endif
    29. 

  29. 

  30. typedef struct
    31. 

  31. {
    32. 

  32. 	TimeADT		time;			/* all time units other than months and years */
    33. 

  33. 	int32		zone;			/* numeric time zone, in seconds */
    34. 

  34. } TimeTzADT;
    35. 

  35. 

  36. /*
    37. 

  37.  * Infinity and minus infinity must be the max and min values of DateADT.
    38. 

  38.  */
    39. 

  39. #define DATEVAL_NOBEGIN		((DateADT) PG_INT32_MIN)
    40. 

  40. #define DATEVAL_NOEND		((DateADT) PG_INT32_MAX)
    41. 

  41. 

  42. #define DATE_NOBEGIN(j)		((j) = DATEVAL_NOBEGIN)
    43. 

  43. #define DATE_IS_NOBEGIN(j)	((j) == DATEVAL_NOBEGIN)
    44. 

  44. #define DATE_NOEND(j)		((j) = DATEVAL_NOEND)
    45. 

  45. #define DATE_IS_NOEND(j)	((j) == DATEVAL_NOEND)
    46. 

  46. #define DATE_NOT_FINITE(j)	(DATE_IS_NOBEGIN(j) || DATE_IS_NOEND(j))
    47. 

  47. 

  48. /*
    49. 

  49.  * Macros for fmgr-callable functions.
    50. 

  50.  *
    51. 

  51.  * For TimeADT, we make use of the same support routines as for float8 or int64.
    52. 

  52.  * Therefore TimeADT is pass-by-reference if and only if float8 or int64 is!
    53. 

  53.  */
    54. 

  54. #ifdef HAVE_INT64_TIMESTAMP
    55. 

  55. 

  56. #define MAX_TIME_PRECISION 6
    57. 

  57. 

  58. #define DatumGetDateADT(X)	  ((DateADT) DatumGetInt32(X))
    59. 

  59. #define DatumGetTimeADT(X)	  ((TimeADT) DatumGetInt64(X))
    60. 

  60. #define DatumGetTimeTzADTP(X) ((TimeTzADT *) DatumGetPointer(X))
    61. 

  61. 

  62. #define DateADTGetDatum(X)	  Int32GetDatum(X)
    63. 

  63. #define TimeADTGetDatum(X)	  Int64GetDatum(X)
    64. 

  64. #define TimeTzADTPGetDatum(X) PointerGetDatum(X)
    65. 

  65. #else							/* !HAVE_INT64_TIMESTAMP */
    66. 

  66. 

  67. #define MAX_TIME_PRECISION 10
    68. 

  68. 

  69. /* round off to MAX_TIME_PRECISION decimal places */
    70. 

  70. #define TIME_PREC_INV 10000000000.0
    71. 

  71. #define TIMEROUND(j) (rint(((double) (j)) * TIME_PREC_INV) / TIME_PREC_INV)
    72. 

  72. 

  73. #define DatumGetDateADT(X)	  ((DateADT) DatumGetInt32(X))
    74. 

  74. #define DatumGetTimeADT(X)	  ((TimeADT) DatumGetFloat8(X))
    75. 

  75. #define DatumGetTimeTzADTP(X) ((TimeTzADT *) DatumGetPointer(X))
    76. 

  76. 

  77. #define DateADTGetDatum(X)	  Int32GetDatum(X)
    78. 

  78. #define TimeADTGetDatum(X)	  Float8GetDatum(X)
    79. 

  79. #define TimeTzADTPGetDatum(X) PointerGetDatum(X)
    80. 

  80. #endif   /* HAVE_INT64_TIMESTAMP */
    81. 

  81. 

  82. #define PG_GETARG_DATEADT(n)	 DatumGetDateADT(PG_GETARG_DATUM(n))
    83. 

  83. #define PG_GETARG_TIMEADT(n)	 DatumGetTimeADT(PG_GETARG_DATUM(n))
    84. 

  84. #define PG_GETARG_TIMETZADT_P(n) DatumGetTimeTzADTP(PG_GETARG_DATUM(n))
    85. 

  85. 

  86. #define PG_RETURN_DATEADT(x)	 return DateADTGetDatum(x)
    87. 

  87. #define PG_RETURN_TIMEADT(x)	 return TimeADTGetDatum(x)
    88. 

  88. #define PG_RETURN_TIMETZADT_P(x) return TimeTzADTPGetDatum(x)
    89. 

  89. 

  90. 

  91. /* date.c */
    92. 

  92. extern double date2timestamp_no_overflow(DateADT dateVal);
    93. 

  93. extern void EncodeSpecialDate(DateADT dt, char *str);
    94. 

  94. 

  95. extern Datum date_in(PG_FUNCTION_ARGS);
    96. 

  96. extern Datum date_out(PG_FUNCTION_ARGS);
    97. 

  97. extern Datum date_recv(PG_FUNCTION_ARGS);
    98. 

  98. extern Datum date_send(PG_FUNCTION_ARGS);
    99. 

  99. extern Datum make_date(PG_FUNCTION_ARGS);
    100. 

  100. extern Datum date_eq(PG_FUNCTION_ARGS);
    101. 

  101. extern Datum date_ne(PG_FUNCTION_ARGS);
    102. 

  102. extern Datum date_lt(PG_FUNCTION_ARGS);
    103. 

  103. extern Datum date_le(PG_FUNCTION_ARGS);
    104. 

  104. extern Datum date_gt(PG_FUNCTION_ARGS);
    105. 

  105. extern Datum date_ge(PG_FUNCTION_ARGS);
    106. 

  106. extern Datum date_cmp(PG_FUNCTION_ARGS);
    107. 

  107. extern Datum date_sortsupport(PG_FUNCTION_ARGS);
    108. 

  108. extern Datum date_finite(PG_FUNCTION_ARGS);
    109. 

  109. extern Datum date_larger(PG_FUNCTION_ARGS);
    110. 

  110. extern Datum date_smaller(PG_FUNCTION_ARGS);
    111. 

  111. extern Datum date_mi(PG_FUNCTION_ARGS);
    112. 

  112. extern Datum date_pli(PG_FUNCTION_ARGS);
    113. 

  113. extern Datum date_mii(PG_FUNCTION_ARGS);
    114. 

  114. extern Datum date_eq_timestamp(PG_FUNCTION_ARGS);
    115. 

  115. extern Datum date_ne_timestamp(PG_FUNCTION_ARGS);
    116. 

  116. extern Datum date_lt_timestamp(PG_FUNCTION_ARGS);
    117. 

  117. extern Datum date_le_timestamp(PG_FUNCTION_ARGS);
    118. 

  118. extern Datum date_gt_timestamp(PG_FUNCTION_ARGS);
    119. 

  119. extern Datum date_ge_timestamp(PG_FUNCTION_ARGS);
    120. 

  120. extern Datum date_cmp_timestamp(PG_FUNCTION_ARGS);
    121. 

  121. extern Datum date_eq_timestamptz(PG_FUNCTION_ARGS);
    122. 

  122. extern Datum date_ne_timestamptz(PG_FUNCTION_ARGS);
    123. 

  123. extern Datum date_lt_timestamptz(PG_FUNCTION_ARGS);
    124. 

  124. extern Datum date_le_timestamptz(PG_FUNCTION_ARGS);
    125. 

  125. extern Datum date_gt_timestamptz(PG_FUNCTION_ARGS);
    126. 

  126. extern Datum date_ge_timestamptz(PG_FUNCTION_ARGS);
    127. 

  127. extern Datum date_cmp_timestamptz(PG_FUNCTION_ARGS);
    128. 

  128. extern Datum timestamp_eq_date(PG_FUNCTION_ARGS);
    129. 

  129. extern Datum timestamp_ne_date(PG_FUNCTION_ARGS);
    130. 

  130. extern Datum timestamp_lt_date(PG_FUNCTION_ARGS);
    131. 

  131. extern Datum timestamp_le_date(PG_FUNCTION_ARGS);
    132. 

  132. extern Datum timestamp_gt_date(PG_FUNCTION_ARGS);
    133. 

  133. extern Datum timestamp_ge_date(PG_FUNCTION_ARGS);
    134. 

  134. extern Datum timestamp_cmp_date(PG_FUNCTION_ARGS);
    135. 

  135. extern Datum timestamptz_eq_date(PG_FUNCTION_ARGS);
    136. 

  136. extern Datum timestamptz_ne_date(PG_FUNCTION_ARGS);
    137. 

  137. extern Datum timestamptz_lt_date(PG_FUNCTION_ARGS);
    138. 

  138. extern Datum timestamptz_le_date(PG_FUNCTION_ARGS);
    139. 

  139. extern Datum timestamptz_gt_date(PG_FUNCTION_ARGS);
    140. 

  140. extern Datum timestamptz_ge_date(PG_FUNCTION_ARGS);
    141. 

  141. extern Datum timestamptz_cmp_date(PG_FUNCTION_ARGS);
    142. 

  142. extern Datum date_pl_interval(PG_FUNCTION_ARGS);
    143. 

  143. extern Datum date_mi_interval(PG_FUNCTION_ARGS);
    144. 

  144. extern Datum date_timestamp(PG_FUNCTION_ARGS);
    145. 

  145. extern Datum timestamp_date(PG_FUNCTION_ARGS);
    146. 

  146. extern Datum date_timestamptz(PG_FUNCTION_ARGS);
    147. 

  147. extern Datum timestamptz_date(PG_FUNCTION_ARGS);
    148. 

  148. extern Datum datetime_timestamp(PG_FUNCTION_ARGS);
    149. 

  149. extern Datum abstime_date(PG_FUNCTION_ARGS);
    150. 

  150. 

  151. extern Datum time_in(PG_FUNCTION_ARGS);
    152. 

  152. extern Datum time_out(PG_FUNCTION_ARGS);
    153. 

  153. extern Datum time_recv(PG_FUNCTION_ARGS);
    154. 

  154. extern Datum time_send(PG_FUNCTION_ARGS);
    155. 

  155. extern Datum timetypmodin(PG_FUNCTION_ARGS);
    156. 

  156. extern Datum timetypmodout(PG_FUNCTION_ARGS);
    157. 

  157. extern Datum make_time(PG_FUNCTION_ARGS);
    158. 

  158. extern Datum time_transform(PG_FUNCTION_ARGS);
    159. 

  159. extern Datum time_scale(PG_FUNCTION_ARGS);
    160. 

  160. extern Datum time_eq(PG_FUNCTION_ARGS);
    161. 

  161. extern Datum time_ne(PG_FUNCTION_ARGS);
    162. 

  162. extern Datum time_lt(PG_FUNCTION_ARGS);
    163. 

  163. extern Datum time_le(PG_FUNCTION_ARGS);
    164. 

  164. extern Datum time_gt(PG_FUNCTION_ARGS);
    165. 

  165. extern Datum time_ge(PG_FUNCTION_ARGS);
    166. 

  166. extern Datum time_cmp(PG_FUNCTION_ARGS);
    167. 

  167. extern Datum time_hash(PG_FUNCTION_ARGS);
    168. 

  168. extern Datum overlaps_time(PG_FUNCTION_ARGS);
    169. 

  169. extern Datum time_larger(PG_FUNCTION_ARGS);
    170. 

  170. extern Datum time_smaller(PG_FUNCTION_ARGS);
    171. 

  171. extern Datum time_mi_time(PG_FUNCTION_ARGS);
    172. 

  172. extern Datum timestamp_time(PG_FUNCTION_ARGS);
    173. 

  173. extern Datum timestamptz_time(PG_FUNCTION_ARGS);
    174. 

  174. extern Datum time_interval(PG_FUNCTION_ARGS);
    175. 

  175. extern Datum interval_time(PG_FUNCTION_ARGS);
    176. 

  176. extern Datum time_pl_interval(PG_FUNCTION_ARGS);
    177. 

  177. extern Datum time_mi_interval(PG_FUNCTION_ARGS);
    178. 

  178. extern Datum time_part(PG_FUNCTION_ARGS);
    179. 

  179. 

  180. extern Datum timetz_in(PG_FUNCTION_ARGS);
    181. 

  181. extern Datum timetz_out(PG_FUNCTION_ARGS);
    182. 

  182. extern Datum timetz_recv(PG_FUNCTION_ARGS);
    183. 

  183. extern Datum timetz_send(PG_FUNCTION_ARGS);
    184. 

  184. extern Datum timetztypmodin(PG_FUNCTION_ARGS);
    185. 

  185. extern Datum timetztypmodout(PG_FUNCTION_ARGS);
    186. 

  186. extern Datum timetz_scale(PG_FUNCTION_ARGS);
    187. 

  187. extern Datum timetz_eq(PG_FUNCTION_ARGS);
    188. 

  188. extern Datum timetz_ne(PG_FUNCTION_ARGS);
    189. 

  189. extern Datum timetz_lt(PG_FUNCTION_ARGS);
    190. 

  190. extern Datum timetz_le(PG_FUNCTION_ARGS);
    191. 

  191. extern Datum timetz_gt(PG_FUNCTION_ARGS);
    192. 

  192. extern Datum timetz_ge(PG_FUNCTION_ARGS);
    193. 

  193. extern Datum timetz_cmp(PG_FUNCTION_ARGS);
    194. 

  194. extern Datum timetz_hash(PG_FUNCTION_ARGS);
    195. 

  195. extern Datum overlaps_timetz(PG_FUNCTION_ARGS);
    196. 

  196. extern Datum timetz_larger(PG_FUNCTION_ARGS);
    197. 

  197. extern Datum timetz_smaller(PG_FUNCTION_ARGS);
    198. 

  198. extern Datum timetz_time(PG_FUNCTION_ARGS);
    199. 

  199. extern Datum time_timetz(PG_FUNCTION_ARGS);
    200. 

  200. extern Datum timestamptz_timetz(PG_FUNCTION_ARGS);
    201. 

  201. extern Datum datetimetz_timestamptz(PG_FUNCTION_ARGS);
    202. 

  202. extern Datum timetz_part(PG_FUNCTION_ARGS);
    203. 

  203. extern Datum timetz_zone(PG_FUNCTION_ARGS);
    204. 

  204. extern Datum timetz_izone(PG_FUNCTION_ARGS);
    205. 

  205. extern Datum timetz_pl_interval(PG_FUNCTION_ARGS);
    206. 

  206. extern Datum timetz_mi_interval(PG_FUNCTION_ARGS);
    207. 

  207. 

  208. #endif   /* DATE_H */
    209.