Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit17d6324

Browse files
author
Thomas G. Lockhart
committed
Define conversions to and from text for date, time, and timetz.
1 parent89a99cb commit17d6324

File tree

3 files changed

+23
-4
lines changed

3 files changed

+23
-4
lines changed

‎src/include/catalog/catversion.h

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -37,7 +37,7 @@
3737
* Portions Copyright (c) 1996-2000, PostgreSQL, Inc
3838
* Portions Copyright (c) 1994, Regents of the University of California
3939
*
40-
* $Id: catversion.h,v 1.57 2000/11/10 20:13:26 tgl Exp $
40+
* $Id: catversion.h,v 1.58 2000/11/11 19:55:33 thomas Exp $
4141
*
4242
*-------------------------------------------------------------------------
4343
*/
@@ -53,6 +53,6 @@
5353
*/
5454

5555
/*yyyymmddN */
56-
#defineCATALOG_VERSION_NO200011101
56+
#defineCATALOG_VERSION_NO200011110
5757

5858
#endif

‎src/include/catalog/pg_proc.h

Lines changed: 14 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
* Portions Copyright (c) 1996-2000, PostgreSQL, Inc
88
* Portions Copyright (c) 1994, Regents of the University of California
99
*
10-
* $Id: pg_proc.h,v 1.173 2000/11/10 20:13:26 tgl Exp $
10+
* $Id: pg_proc.h,v 1.174 2000/11/11 19:55:33 thomas Exp $
1111
*
1212
* NOTES
1313
* The script catalog/genbki.sh reads this file and generates .bki
@@ -1256,6 +1256,19 @@ DESCR("horizontal?");
12561256
DATA(insertOID=999 (lseg_eqPGUID12fttt2f16"601 601"10000100lseg_eq- ));
12571257
DESCR("equal");
12581258

1259+
DATA(insertOID=748 (datePGUID12fttt1f1082"25"10000100text_date- ));
1260+
DESCR("convert text to date");
1261+
DATA(insertOID=749 (textPGUID12fttt1f25"1082"10000100date_text- ));
1262+
DESCR("convert date to text");
1263+
DATA(insertOID=837 (timePGUID12fttt1f1083"25"10000100text_time- ));
1264+
DESCR("convert text to date");
1265+
DATA(insertOID=948 (textPGUID12fttt1f25"1083"10000100time_text- ));
1266+
DESCR("convert time to text");
1267+
DATA(insertOID=938 (timetzPGUID12fttt1f1266"25"10000100text_timetz- ));
1268+
DESCR("convert text to date");
1269+
DATA(insertOID=939 (textPGUID12fttt1f25"1266"10000100timetz_text- ));
1270+
DESCR("convert timetz to text");
1271+
12591272
/* OIDS 1000 - 1999 */
12601273

12611274
DATA(insertOID=1026 (timezonePGUID12ftft2f25"1186 1184"10000100timestamp_izone- ));

‎src/include/utils/date.h

Lines changed: 7 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
* Portions Copyright (c) 1996-2000, PostgreSQL, Inc
88
* Portions Copyright (c) 1994, Regents of the University of California
99
*
10-
* $Id: date.h,v 1.5 2000/06/19 03:54:48 tgl Exp $
10+
* $Id: date.h,v 1.6 2000/11/11 19:55:39 thomas Exp $
1111
*
1212
*-------------------------------------------------------------------------
1313
*/
@@ -70,6 +70,8 @@ extern Datum date_timestamp(PG_FUNCTION_ARGS);
7070
externDatumtimestamp_date(PG_FUNCTION_ARGS);
7171
externDatumdatetime_timestamp(PG_FUNCTION_ARGS);
7272
externDatumabstime_date(PG_FUNCTION_ARGS);
73+
externDatumtext_date(PG_FUNCTION_ARGS);
74+
externDatumdate_text(PG_FUNCTION_ARGS);
7375

7476
externDatumtime_in(PG_FUNCTION_ARGS);
7577
externDatumtime_out(PG_FUNCTION_ARGS);
@@ -85,6 +87,8 @@ extern Datum time_larger(PG_FUNCTION_ARGS);
8587
externDatumtime_smaller(PG_FUNCTION_ARGS);
8688
externDatumtimestamp_time(PG_FUNCTION_ARGS);
8789
externDatumtime_interval(PG_FUNCTION_ARGS);
90+
externDatumtext_time(PG_FUNCTION_ARGS);
91+
externDatumtime_text(PG_FUNCTION_ARGS);
8892

8993
externDatumtimetz_in(PG_FUNCTION_ARGS);
9094
externDatumtimetz_out(PG_FUNCTION_ARGS);
@@ -101,5 +105,7 @@ extern Datum timetz_larger(PG_FUNCTION_ARGS);
101105
externDatumtimetz_smaller(PG_FUNCTION_ARGS);
102106
externDatumtimestamp_timetz(PG_FUNCTION_ARGS);
103107
externDatumdatetimetz_timestamp(PG_FUNCTION_ARGS);
108+
externDatumtext_timetz(PG_FUNCTION_ARGS);
109+
externDatumtimetz_text(PG_FUNCTION_ARGS);
104110

105111
#endif/* DATE_H */

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp