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

Commita9a91b5

Browse files
author
Thomas G. Lockhart
committed
Add conversion functions for int2, int4, oid to and from text.
Shorten a few routine names to <= 16 characters long to fit in table.
1 parentb5f582b commita9a91b5

File tree

1 file changed

+33
-19
lines changed

1 file changed

+33
-19
lines changed

‎src/include/catalog/pg_proc.h‎

Lines changed: 33 additions & 19 deletions
Original file line numberDiff line numberDiff line change
@@ -6,7 +6,7 @@
66
*
77
* Copyright (c) 1994, Regents of the University of California
88
*
9-
* $Id: pg_proc.h,v 1.31 1997/09/20 16:29:38 thomas Exp $
9+
* $Id: pg_proc.h,v 1.32 1997/10/25 05:29:48 thomas Exp $
1010
*
1111
* NOTES
1212
* The script catalog/genbki.sh reads this file and generates .bki
@@ -181,6 +181,10 @@ DATA(insert OID = 106 ( neqjoinsel PGUID 11 f t f 5 f 701 "26 26 21 26 21"
181181
DATA(insertOID=107 (intltjoinselPGUID11ftf5f701"26 26 21 26 21"10000100foobar ));
182182
DATA(insertOID=108 (intgtjoinselPGUID11ftf5f701"26 26 21 26 21"10000100foobar ));
183183

184+
DATA(insertOID=112 (int4_textPGUID11ftf1f25"23"10000100foobar ));
185+
DATA(insertOID=113 (int2_textPGUID11ftf1f25"21"10000100foobar ));
186+
DATA(insertOID=114 (oid_textPGUID11ftf1f25"26"10000100foobar ));
187+
184188
DATA(insertOID=115 (box_abovePGUID11ftf2f16"603 603"10010100foobar ));
185189
DATA(insertOID=116 (box_belowPGUID11ftf2f16"603 603"10010100foobar ));
186190

@@ -625,6 +629,10 @@ DATA(insert OID = 789 ( intervalge PGUID 11 f t f 2 f 16 "704 704" 100 0 0
625629

626630
/* OIDS 800 - 899 */
627631

632+
DATA(insertOID=817 (text_oidPGUID11ftf1f26"25"10000100foobar));
633+
DATA(insertOID=818 (text_int2PGUID11ftf1f21"25"10000100foobar));
634+
DATA(insertOID=819 (text_int4PGUID11ftf1f23"25"10000100foobar));
635+
628636
DATA(insertOID=820 (oidint2inPGUID11ftf1f810"0"10000100foobar));
629637
DATA(insertOID=821 (oidint2outPGUID11ftf1f19"0"10000100foobar));
630638
DATA(insertOID=822 (oidint2ltPGUID11ftf2f16"810 810"10000100foobar));
@@ -686,6 +694,7 @@ DATA(insert OID = 899 ( cashsmaller PGUID 11 f t f 2 f 790 "790 790" 100 0
686694
DATA(insertOID=919 (flt8_mul_cashPGUID11ftf2f790"701 790"10000100foobar ));
687695

688696
/* OIDS 900 - 999 */
697+
689698
DATA(insertOID=920 (oidint4inPGUID11ftf1f910"0"10000100foobar));
690699
DATA(insertOID=921 (oidint4outPGUID11ftf1f19"0"10000100foobar));
691700
DATA(insertOID=922 (oidint4ltPGUID11ftf2f16"910 910"10000100foobar));
@@ -857,8 +866,8 @@ DATA(insert OID = 1172 ( timespan_part PGUID 11 f t f 2 f 701 "25 1186" 100
857866

858867
DATA(insertOID=1173 (abstime_datetimePGUID11ftf1f1184"702"10000100foobar ));
859868
DATA(insertOID=1174 (date_datetimePGUID11ftf1f1184"1082"10000100foobar ));
860-
DATA(insertOID=1175 (timestamp_datetimePGUID11ftf1f1184"1296"10000100foobar ));
861-
DATA(insertOID=1176 (datetime_datetimePGUID11ftf2f1184"1082 1083"10000100foobar ));
869+
DATA(insertOID=1175 (stamp_datetimePGUID11ftf1f1184"1296"10000100foobar ));
870+
DATA(insertOID=1176 (datet_datetimePGUID11ftf2f1184"1082 1083"10000100foobar ));
862871
DATA(insertOID=1177 (reltime_timespanPGUID11ftf1f1186"703"10000100foobar ));
863872
DATA(insertOID=1178 (datetime_datePGUID11ftf1f1082"1184"10000100foobar ));
864873
DATA(insertOID=1179 (abstime_datePGUID11ftf1f1082"702"10000100foobar ));
@@ -898,32 +907,39 @@ DATA(insert OID = 1240 ( nameicregexeq PGUID 11 f t f 2 f 16 "19 25" 100 0 0
898907
DATA(insertOID=1241 (nameicregexnePGUID11ftf2f16"19 25"10000100foobar ));
899908

900909
DATA(insertOID=1297 (timestamp_inPGUID11ftf1f1296"0"10000100foobar ));
901-
DATA(insertOID=1298 (timestamp_outPGUID11ftf1f23"0"10000100foobar ));
910+
DATA(insertOID=1298 (timestamp_outPGUID11ftf1f23"0"10000100foobar ));
902911
DATA(insertOID=1299 (nowPGUID11ftf0f1296"0"10000100foobar ));
903912

904913
/* OIDS 1300 - 1399 */
905914

906-
DATA(insertOID=1306 (timestampeqPGUID11ftf2f16"1296 1296"10000100foobar ));
907-
DATA(insertOID=1307 (timestampnePGUID11ftf2f16"1296 1296"10000100foobar ));
908-
DATA(insertOID=1308 (timestampltPGUID11ftf2f16"1296 1296"10000100foobar ));
909-
DATA(insertOID=1309 (timestampgtPGUID11ftf2f16"1296 1296"10000100foobar ));
910-
DATA(insertOID=1310 (timestamplePGUID11ftf2f16"1296 1296"10000100foobar ));
911-
DATA(insertOID=1311 (timestampgePGUID11ftf2f16"1296 1296"10000100foobar ));
912-
/* reserve OIDs 1312-1319 for additional date/time conversion routines! tgl 97/04/01 */
913-
DATA(insertOID=1314 (datetime_cmpPGUID11ftf2f23"1184 1184"10000100foobar ));
914-
DATA(insertOID=1315 (timespan_cmpPGUID11ftf2f23"1186 1186"10000100foobar ));
915+
DATA(insertOID=1306 (timestampeqPGUID11ftf2f16"1296 1296"10000100foobar ));
916+
DATA(insertOID=1307 (timestampnePGUID11ftf2f16"1296 1296"10000100foobar ));
917+
DATA(insertOID=1308 (timestampltPGUID11ftf2f16"1296 1296"10000100foobar ));
918+
DATA(insertOID=1309 (timestampgtPGUID11ftf2f16"1296 1296"10000100foobar ));
919+
DATA(insertOID=1310 (timestamplePGUID11ftf2f16"1296 1296"10000100foobar ));
920+
DATA(insertOID=1311 (timestampgePGUID11ftf2f16"1296 1296"10000100foobar ));
921+
DATA(insertOID=1314 (datetime_cmpPGUID11ftf2f23"1184 1184"10000100foobar ));
922+
DATA(insertOID=1315 (timespan_cmpPGUID11ftf2f23"1186 1186"10000100foobar ));
923+
DATA(insertOID=1316 (datetime_timePGUID11ftf1f1083"1184"10000100foobar ));
924+
DATA(insertOID=1318 (datetime_stampPGUID11ftf1f1296"1184"10000100foobar ));
925+
DATA(insertOID=1326 (timespan_divPGUID11ftf2f1186"1186 701"10000100foobar ));
915926

916927
DATA(insertOID=1339 (date_zonePGUID14ftf2f25"25 1184"10000100"select datetime_zone($1, $2)"- ));
917928
DATA(insertOID=1340 (textPGUID14ftf1f25"1184"10000100"select datetime_text($1)"- ));
918929
DATA(insertOID=1341 (textPGUID14ftf1f25"1186"10000100"select timespan_text($1)"- ));
919-
/* reserve OIDs 1339-1349 for additional date/time conversion routines! tgl 97/04/01 */
930+
DATA(insertOID=1342 (textPGUID14ftf1f25"23"10000100"select int4_text($1)"- ));
931+
DATA(insertOID=1343 (textPGUID14ftf1f25"21"10000100"select int2_text($1)"- ));
932+
DATA(insertOID=1344 (textPGUID14ftf1f25"26"10000100"select oid_text($1)"- ));
933+
DATA(insertOID=1345 (oidPGUID14ftf1f26"25"10000100"select text_oid($1)"- ));
934+
DATA(insertOID=1346 (int2PGUID14ftf1f21"25"10000100"select text_int2($1)"- ));
935+
DATA(insertOID=1347 (int4PGUID14ftf1f23"25"10000100"select text_int4($1)"- ));
920936

921937
DATA(insertOID=1350 (datetimePGUID14ftf1f1184"1184"10000100"select $1"- ));
922938
DATA(insertOID=1351 (datetimePGUID14ftf1f1184"25"10000100"select text_datetime($1)"- ));
923939
DATA(insertOID=1352 (datetimePGUID14ftf1f1184"702"10000100"select abstime_datetime($1)"- ));
924940
DATA(insertOID=1353 (datetimePGUID14ftf1f1184"1082"10000100"select date_datetime($1)"- ));
925-
DATA(insertOID=1354 (datetimePGUID14ftf1f1184"1296"10000100"selecttimestamp_datetime($1)"- ));
926-
DATA(insertOID=1355 (datetimePGUID14ftf2f1184"1082 1083"10000100"selectdatetime_datetime($1, $2)"- ));
941+
DATA(insertOID=1354 (datetimePGUID14ftf1f1184"1296"10000100"selectstamp_datetime($1)"- ));
942+
DATA(insertOID=1355 (datetimePGUID14ftf2f1184"1082 1083"10000100"selectdatet_datetime($1, $2)"- ));
927943
DATA(insertOID=1356 (timespanPGUID14ftf1f1186"1186"10000100"select $1"- ));
928944
DATA(insertOID=1357 (timespanPGUID14ftf1f1186"703"10000100"select reltime_timespan($1)"- ));
929945
DATA(insertOID=1358 (timespanPGUID14ftf1f1186"1083"10000100"select time_timespan($1)"- ));
@@ -938,7 +954,7 @@ DATA(insert OID = 1366 ( abstime PGUID 14 f t f 1 f 702 "1184" 100 0 0 100
938954
DATA(insertOID=1367 (reltimePGUID14ftf1f703"703"10000100"select $1"- ));
939955
DATA(insertOID=1368 (reltimePGUID14ftf1f703"1186"10000100"select timespan_reltime($1)"- ));
940956
DATA(insertOID=1369 (timestampPGUID14ftf1f1296"1296"10000100"select $1"- ));
941-
DATA(insertOID=1370 (timestampPGUID14ftf1f1296"1184"10000100"selectdatetime_timestamp($1)"- ));
957+
DATA(insertOID=1370 (timestampPGUID14ftf1f1296"1184"10000100"selectdatetime_stamp($1)"- ));
942958

943959
DATA(insertOID=1380 (date_partPGUID14ftf2f701"25 1184"10000100"select datetime_part($1, $2)"- ));
944960
DATA(insertOID=1381 (date_partPGUID14ftf2f701"25 1186"10000100"select timespan_part($1, $2)"- ));
@@ -1112,8 +1128,6 @@ DATA(insert OID = 882 ( rtrim PGUID 14 f t f 1 f 25 "25" 100 0 0 100 "sel
11121128
DATA(insertOID=883 (substrPGUID14ftf2f25"25 23"10000100"select substr($1, $2, 10000)"- ));
11131129
DATA(insertOID=884 (btrimPGUID11ftf2f25"25 25"10000100foobar ));
11141130
DATA(insertOID=885 (btrimPGUID14ftf1f25"25"10000100"select btrim($1, \' \')"- ));
1115-
/* XXX Help, where should I go to */
1116-
DATA(insertOID=1586 (timespan_divPGUID11ftf2f1186"1186 701"10000100foobar ));
11171131

11181132
/* SEQUENCEs nextval & currval functions */
11191133
DATA(insertOID=1317 (nextvalPGUID11ftf1f23"25"10000100foobar ));

0 commit comments

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