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

Commitd16b476

Browse files
author
Thomas G. Lockhart
committed
Remove duplicate block of declarations. Must have been introduced recently
 since I've run ./duplicate_oids (and found no problems) in the last couple of months.Add and modify some DESCR() entries to describe functions.
1 parentabedcdd commitd16b476

File tree

1 file changed

+74
-73
lines changed

1 file changed

+74
-73
lines changed

‎src/include/catalog/pg_proc.h

Lines changed: 74 additions & 73 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.38 1997/11/24 13:43:29 momjian Exp $
9+
* $Id: pg_proc.h,v 1.39 1997/11/30 22:52:24 thomas Exp $
1010
*
1111
* NOTES
1212
* The script catalog/genbki.sh reads this file and generates .bki
@@ -1517,26 +1517,26 @@ DESCR("addition");
15171517
DATA(insertOID=1170 (timespan_miPGUID11ftf2f1186"1186 1186"10000100foobar ));
15181518
DESCR("subtract");
15191519
DATA(insertOID=1171 (datetime_partPGUID11ftf2f701"25 1184"10000100foobar ));
1520-
DESCR("get part of datetime field");
1520+
DESCR("extract field from datetime");
15211521
DATA(insertOID=1172 (timespan_partPGUID11ftf2f701"25 1186"10000100foobar ));
1522-
DESCR("get part of timespan field");
1522+
DESCR("extract field from timespan");
15231523

15241524
DATA(insertOID=1173 (abstime_datetimePGUID11ftf1f1184"702"10000100foobar ));
1525-
DESCR("convert");
1525+
DESCR("convert abstime to datetime");
15261526
DATA(insertOID=1174 (date_datetimePGUID11ftf1f1184"1082"10000100foobar ));
1527-
DESCR("convert");
1527+
DESCR("convert date to datetime");
15281528
DATA(insertOID=1175 (stamp_datetimePGUID11ftf1f1184"1296"10000100foobar ));
1529-
DESCR("convert");
1529+
DESCR("convert timestamp to datetime");
15301530
DATA(insertOID=1176 (datet_datetimePGUID11ftf2f1184"1082 1083"10000100foobar ));
1531-
DESCR("convert");
1531+
DESCR("convert date and time to datetime");
15321532
DATA(insertOID=1177 (reltime_timespanPGUID11ftf1f1186"703"10000100foobar ));
1533-
DESCR("convert");
1533+
DESCR("convert reltime to timespan");
15341534
DATA(insertOID=1178 (datetime_datePGUID11ftf1f1082"1184"10000100foobar ));
1535-
DESCR("convert");
1535+
DESCR("convert datetime to date");
15361536
DATA(insertOID=1179 (abstime_datePGUID11ftf1f1082"702"10000100foobar ));
1537-
DESCR("convert");
1537+
DESCR("convert abstime to date");
15381538
DATA(insertOID=1180 (datetime_abstimePGUID11ftf1f702"1184"10000100foobar ));
1539-
DESCR("convert");
1539+
DESCR("convert datetime to abstime");
15401540

15411541
DATA(insertOID=1188 (datetime_miPGUID11ftf2f1186"1184 1184"10000100foobar ));
15421542
DESCR("subtract");
@@ -1573,18 +1573,6 @@ DESCR("truncate datetime to specified units");
15731573
DATA(insertOID=1218 (timespan_truncPGUID11ftf2f1186"25 1186"10000100foobar ));
15741574
DESCR("truncate timespan to specified units");
15751575

1576-
DATA(insertOID=1290 (char2icregexeqPGUID11ftf2f16"409 25"10000100foobar ));
1577-
DESCR("matches regex., case-insensitive");
1578-
DATA(insertOID=1291 (char2icregexnePGUID11ftf2f16"409 25"10000100foobar ));
1579-
DESCR("does not match regex., case-insensitive");
1580-
DATA(insertOID=1292 (char4icregexeqPGUID11ftf2f16"410 25"10000100foobar ));
1581-
DESCR("matches regex., case-insensitive");
1582-
DATA(insertOID=1293 (char4icregexnePGUID11ftf2f16"410 25"10000100foobar ));
1583-
DESCR("does not match regex., case-insensitive");
1584-
DATA(insertOID=1294 (char8icregexeqPGUID11ftf2f16"411 25"10000100foobar ));
1585-
DESCR("matches regex., case-insensitive");
1586-
DATA(insertOID=1295 (char8icregexnePGUID11ftf2f16"411 25"10000100foobar ));
1587-
DESCR("does not match regex., case-insensitive");
15881576
DATA(insertOID=1236 (char16icregexeqPGUID11ftf2f16"20 25"10000100foobar ));
15891577
DESCR("matches regex., case-insensitive");
15901578
DATA(insertOID=1237 (char16icregexnePGUID11ftf2f16"20 25"10000100foobar ));
@@ -1598,12 +1586,25 @@ DESCR("matches regex., case-insensitive");
15981586
DATA(insertOID=1241 (nameicregexnePGUID11ftf2f16"19 25"10000100foobar ));
15991587
DESCR("does not match regex., case-insensitive");
16001588

1589+
DATA(insertOID=1290 (char2icregexeqPGUID11ftf2f16"409 25"10000100foobar ));
1590+
DESCR("matches regex., case-insensitive");
1591+
DATA(insertOID=1291 (char2icregexnePGUID11ftf2f16"409 25"10000100foobar ));
1592+
DESCR("does not match regex., case-insensitive");
1593+
DATA(insertOID=1292 (char4icregexeqPGUID11ftf2f16"410 25"10000100foobar ));
1594+
DESCR("matches regex., case-insensitive");
1595+
DATA(insertOID=1293 (char4icregexnePGUID11ftf2f16"410 25"10000100foobar ));
1596+
DESCR("does not match regex., case-insensitive");
1597+
DATA(insertOID=1294 (char8icregexeqPGUID11ftf2f16"411 25"10000100foobar ));
1598+
DESCR("matches regex., case-insensitive");
1599+
DATA(insertOID=1295 (char8icregexnePGUID11ftf2f16"411 25"10000100foobar ));
1600+
DESCR("does not match regex., case-insensitive");
1601+
16011602
DATA(insertOID=1297 (timestamp_inPGUID11ftf1f1296"0"10000100foobar ));
16021603
DESCR("(internal)");
16031604
DATA(insertOID=1298 (timestamp_outPGUID11ftf1f23"0"10000100foobar ));
16041605
DESCR("(internal)");
16051606
DATA(insertOID=1299 (nowPGUID11ftf0f1296"0"10000100foobar ));
1606-
DESCR("(internal)");
1607+
DESCR("current transaction time");
16071608

16081609
/* OIDS 1300 - 1399 */
16091610

@@ -1697,25 +1698,25 @@ DATA(insert OID = 1370 ( timestamp PGUID 14 f t f 1 f 1296 "1184" 100 0 0 10
16971698
DESCR("convert");
16981699

16991700
DATA(insertOID=1380 (date_partPGUID14ftf2f701"25 1184"10000100"select datetime_part($1, $2)"- ));
1700-
DESCR("get part of date");
1701+
DESCR("extract field from datetime");
17011702
DATA(insertOID=1381 (date_partPGUID14ftf2f701"25 1186"10000100"select timespan_part($1, $2)"- ));
1702-
DESCR("get part of date");
1703+
DESCR("extract field from timespan");
17031704
DATA(insertOID=1382 (date_partPGUID14ftf2f701"25 702"10000100"select datetime_part($1, datetime($2))"- ));
1704-
DESCR("get part of date");
1705+
DESCR("extract field from abstime");
17051706
DATA(insertOID=1383 (date_partPGUID14ftf2f701"25 703"10000100"select timespan_part($1, timespan($2))"- ));
1706-
DESCR("get part of date");
1707+
DESCR("extract field from reltime");
17071708
DATA(insertOID=1384 (date_partPGUID14ftf2f701"25 1082"10000100"select datetime_part($1, datetime($2))"- ));
1708-
DESCR("get part of date");
1709+
DESCR("extract field from date");
17091710
DATA(insertOID=1385 (date_partPGUID14ftf2f701"25 1083"10000100"select timespan_part($1, timespan($2))"- ));
1710-
DESCR("get part of date");
1711+
DESCR("extract field from time");
17111712
DATA(insertOID=1386 (date_truncPGUID14ftf2f1184"25 1184"10000100"select datetime_trunc($1, $2)"- ));
1712-
DESCR("truncatedate");
1713+
DESCR("truncatedatetime to field");
17131714
DATA(insertOID=1387 (date_truncPGUID14ftf2f1186"25 1186"10000100"select timespan_trunc($1, $2)"- ));
1714-
DESCR("truncatedate");
1715+
DESCR("truncatetimespan to field");
17151716
DATA(insertOID=1388 (agePGUID14ftf2f1186"1184 1184"10000100"select datetime_age($1, $2)"- ));
1716-
DESCR("getdifference");
1717+
DESCR("difference between datetimes but leave years and months unresolved");
17171718
DATA(insertOID=1389 (agePGUID14ftf1f1186"1184"10000100"select datetime_age(\'today\', $1)"- ));
1718-
DESCR("getdifference");
1719+
DESCR("difference between datetime and today but leave years and months unresolved");
17191720

17201721
DATA(insertOID=1390 (isfinitePGUID14ftf1f16"1184"10000100"select datetime_finite($1)"- ));
17211722
DESCR("");
@@ -1728,65 +1729,65 @@ DESCR("");
17281729
/* OIDS 1400 - 1499 */
17291730

17301731
DATA(insertOID=1400 (floatPGUID14ftf1f701"701"10000100"select $1"- ));
1731-
DESCR("convert");
1732+
DESCR("convert float8 to float8 (no-op)");
17321733
DATA(insertOID=1401 (floatPGUID14ftf1f701"700"10000100"select ftod($1)"- ));
1733-
DESCR("convert");
1734+
DESCR("convert float4 to float8");
17341735
DATA(insertOID=1402 (float4PGUID14ftf1f700"700"10000100"select $1"- ));
1735-
DESCR("convert");
1736+
DESCR("convert float4 to float4 (no-op)");
17361737
DATA(insertOID=1403 (float4PGUID14ftf1f700"701"10000100"select dtof($1)"- ));
1737-
DESCR("convert");
1738+
DESCR("convert float8 to float4");
17381739
DATA(insertOID=1404 (intPGUID14ftf1f23"23"10000100"select $1"- ));
1739-
DESCR("convert");
1740+
DESCR("convert int4 to int4 (no-op)");
17401741
DATA(insertOID=1405 (int2PGUID14ftf1f21"21"10000100"select $1"- ));
1741-
DESCR("convert");
1742+
DESCR("convert int2 to int2 (no-op)");
17421743

17431744
DATA(insertOID=1406 (float8PGUID14ftf1f701"701"10000100"select $1"- ));
1744-
DESCR("convert");
1745+
DESCR("convert float8 to float8 (no-op)");
17451746
DATA(insertOID=1407 (float8PGUID14ftf1f701"700"10000100"select ftod($1)"- ));
1746-
DESCR("convert");
1747+
DESCR("convert float4 to float8");
17471748
DATA(insertOID=1408 (float8PGUID14ftf1f701"23"10000100"select i4tod($1)"- ));
1748-
DESCR("convert");
1749+
DESCR("convert int4 to float8");
17491750
DATA(insertOID=1409 (float8PGUID14ftf1f701"21"10000100"select i2tod($1)"- ));
1750-
DESCR("convert");
1751+
DESCR("convert int2 to float8");
17511752
DATA(insertOID=1410 (float4PGUID14ftf1f700"23"10000100"select i4tof($1)"- ));
1752-
DESCR("convert");
1753+
DESCR("convert int4 to float4");
17531754
DATA(insertOID=1411 (float4PGUID14ftf1f700"21"10000100"select i2tof($1)"- ));
1754-
DESCR("convert");
1755+
DESCR("convert int2 to float4");
17551756
DATA(insertOID=1412 (int4PGUID14ftf1f23"23"10000100"select $1"- ));
1756-
DESCR("convert");
1757+
DESCR("convert int4 to int4 (no-op)");
17571758
DATA(insertOID=1413 (int4PGUID14ftf1f23"701"10000100"select dtoi4($1)"- ));
1758-
DESCR("convert");
1759+
DESCR("convert float8 to int4");
17591760
DATA(insertOID=1414 (int4PGUID14ftf1f23"21"10000100"select i2toi4($1)"- ));
1760-
DESCR("convert");
1761+
DESCR("convert int2 to int4");
17611762
DATA(insertOID=1415 (int4PGUID14ftf1f23"700"10000100"select ftoi4($1)"- ));
1762-
DESCR("convert");
1763+
DESCR("convert float4 to int4");
17631764
DATA(insertOID=1416 (int2PGUID14ftf1f21"21"10000100"select $1"- ));
1764-
DESCR("convert");
1765+
DESCR("convert int2 to int2 (no-op)");
17651766
DATA(insertOID=1417 (int2PGUID14ftf1f21"23"10000100"select i4toi2($1)"- ));
1766-
DESCR("convert");
1767+
DESCR("convert int4 to int2");
17671768
DATA(insertOID=1418 (int2PGUID14ftf1f21"701"10000100"select dtoi2($1)"- ));
1768-
DESCR("convert");
1769+
DESCR("convert float8 to int2");
17691770
DATA(insertOID=1419 (int2PGUID14ftf1f21"700"10000100"select ftoi2($1)"- ));
1770-
DESCR("convert");
1771+
DESCR("convert float4 to int2");
17711772

17721773
DATA(insertOID=1421 (boxPGUID11ftf2f603"600 600"10000100foobar ));
1773-
DESCR("convert");
1774+
DESCR("convert points to box");
17741775
DATA(insertOID=1422 (box_addPGUID11ftf2f603"603 600"10000100foobar ));
1775-
DESCR("addition");
1776+
DESCR("add point to box (translate)");
17761777
DATA(insertOID=1423 (box_subPGUID11ftf2f603"603 600"10000100foobar ));
1777-
DESCR("subtract");
1778+
DESCR("subtract point from box (translate)");
17781779
DATA(insertOID=1424 (box_mulPGUID11ftf2f603"603 600"10000100foobar ));
1779-
DESCR("multiply");
1780+
DESCR("multiply box by point (scale)");
17801781
DATA(insertOID=1425 (box_divPGUID11ftf2f603"603 600"10000100foobar ));
1781-
DESCR("divide");
1782+
DESCR("divide box by point (scale)");
17821783
DATA(insertOID=1426 (path_contain_ptPGUID11ftf2f16"601 600"10000100foobar ));
1783-
DESCR("contains");
1784+
DESCR("pathcontains point?");
17841785
DATA(insertOID=1427 (pt_contained_pathPGUID11ftf2f16"600 601"10000100foobar ));
1785-
DESCR("");
1786+
DESCR("point contained in path?");
17861787
DATA(insertOID=1428 (poly_contain_ptPGUID11ftf2f16"604 600"10000100foobar ));
1787-
DESCR("contains");
1788+
DESCR("polygoncontains point?");
17881789
DATA(insertOID=1429 (pt_contained_polyPGUID11ftf2f16"600 604"10000100foobar ));
1789-
DESCR("");
1790+
DESCR("point contained by polygon?");
17901791

17911792
DATA(insertOID=1430 (path_isclosedPGUID11ftf1f16"602"10000100foobar ));
17921793
DESCR("");
@@ -1810,26 +1811,26 @@ DATA(insert OID = 1439 ( path_div_ptPGUID 11 f t f 2 f 602 "602 600" 100 0 0
18101811
DESCR("divide");
18111812

18121813
DATA(insertOID=1440 (pointPGUID11ftf2f600"701 701"10000100foobar ));
1813-
DESCR("");
1814+
DESCR("convert x, y to point");
18141815
DATA(insertOID=1441 (point_addPGUID11ftf2f600"600 600"10000100foobar ));
1815-
DESCR("addition");
1816+
DESCR("add points (translate)");
18161817
DATA(insertOID=1442 (point_subPGUID11ftf2f600"600 600"10000100foobar ));
1817-
DESCR("subtract");
1818+
DESCR("subtract points (translate)");
18181819
DATA(insertOID=1443 (point_mulPGUID11ftf2f600"600 600"10000100foobar ));
1819-
DESCR("multiply");
1820+
DESCR("multiply points (scale/rotate)");
18201821
DATA(insertOID=1444 (point_divPGUID11ftf2f600"600 600"10000100foobar ));
1821-
DESCR("divide");
1822+
DESCR("divide points (scale/rotate)");
18221823

18231824
DATA(insertOID=1445 (poly_npointsPGUID11ftf1f23"604"10000100foobar ));
1824-
DESCR("");
1825+
DESCR("number of points in polygon");
18251826
DATA(insertOID=1446 (poly_boxPGUID11ftf1f603"604"10000100foobar ));
1826-
DESCR("");
1827+
DESCR("convert polygon to bounding box");
18271828
DATA(insertOID=1447 (poly_pathPGUID11ftf1f602"604"10000100foobar ));
1828-
DESCR("");
1829+
DESCR("convert polygon to path");
18291830
DATA(insertOID=1448 (box_polyPGUID11ftf1f604"603"10000100foobar ));
1830-
DESCR("");
1831+
DESCR("convert box to polygon");
18311832
DATA(insertOID=1449 (path_polyPGUID11ftf1f604"602"10000100foobar ));
1832-
DESCR("");
1833+
DESCR("convert path to polygon");
18331834

18341835
DATA(insertOID=1450 (circle_inPGUID11ftf1f718"0"100010foobar ));
18351836
DESCR("(internal)");

0 commit comments

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