77 * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group
88 * Portions Copyright (c) 1994, Regents of the University of California
99 *
10- * $Id: pg_proc.h,v 1.284 2003/02/22 00:45:05 tgl Exp $
10+ * $Id: pg_proc.h,v 1.285 2003/03/03 03:30:46 tgl Exp $
1111 *
1212 * NOTES
1313 * The script catalog/genbki.sh reads this file and generates .bki
@@ -281,11 +281,11 @@ DESCR("is right of");
281281DATA (insert OID = 134 (point_below PGNSP PGUID 12 f f t f i 2 16 "600 600" point_below - _null_ ));
282282DESCR ("is below" );
283283DATA (insert OID = 135 (point_eq PGNSP PGUID 12 f f t f i 2 16 "600 600" point_eq - _null_ ));
284- DESCR ("same as" );
284+ DESCR ("same as? " );
285285DATA (insert OID = 136 (on_pb PGNSP PGUID 12 f f t f i 2 16 "600 603" on_pb - _null_ ));
286- DESCR ("pointis inside" );
286+ DESCR ("point inside box? " );
287287DATA (insert OID = 137 (on_ppath PGNSP PGUID 12 f f t f i 2 16 "600 602" on_ppath - _null_ ));
288- DESCR ("contained in " );
288+ DESCR ("point within closed path, or point on open path " );
289289DATA (insert OID = 138 (box_center PGNSP PGUID 12 f f t f i 1 600 "603" box_center - _null_ ));
290290DESCR ("center of" );
291291DATA (insert OID = 139 (areasel PGNSP PGUID 12 f f t f s 4 701 "2281 26 2281 23" areasel - _null_ ));
@@ -381,19 +381,19 @@ DESCR("equal");
381381DATA (insert OID = 185 (oidne PGNSP PGUID 12 f f t f i 2 16 "26 26" oidne - _null_ ));
382382DESCR ("not equal" );
383383DATA (insert OID = 186 (box_same PGNSP PGUID 12 f f t f i 2 16 "603 603" box_same - _null_ ));
384- DESCR ("same as" );
384+ DESCR ("same as? " );
385385DATA (insert OID = 187 (box_contain PGNSP PGUID 12 f f t f i 2 16 "603 603" box_contain - _null_ ));
386- DESCR ("contains" );
386+ DESCR ("contains? " );
387387DATA (insert OID = 188 (box_left PGNSP PGUID 12 f f t f i 2 16 "603 603" box_left - _null_ ));
388388DESCR ("is left of" );
389389DATA (insert OID = 189 (box_overleft PGNSP PGUID 12 f f t f i 2 16 "603 603" box_overleft - _null_ ));
390- DESCR ("overlaps, but does not extend to right of" );
390+ DESCR ("overlaps or is left of" );
391391DATA (insert OID = 190 (box_overright PGNSP PGUID 12 f f t f i 2 16 "603 603" box_overright - _null_ ));
392- DESCR ("overlaps, but does not extend to left of" );
392+ DESCR ("overlaps or is right of" );
393393DATA (insert OID = 191 (box_right PGNSP PGUID 12 f f t f i 2 16 "603 603" box_right - _null_ ));
394394DESCR ("is right of" );
395395DATA (insert OID = 192 (box_contained PGNSP PGUID 12 f f t f i 2 16 "603 603" box_contained - _null_ ));
396- DESCR ("contained in" );
396+ DESCR ("contained in? " );
397397DATA (insert OID = 193 (rt_box_union PGNSP PGUID 12 f f t f i 2 603 "603 603" rt_box_union - _null_ ));
398398DESCR ("r-tree" );
399399DATA (insert OID = 194 (rt_box_inter PGNSP PGUID 12 f f t f i 2 2278 "603 603" rt_box_inter - _null_ ));
@@ -519,7 +519,7 @@ DESCR("(internal)");
519519DATA (insert OID = 248 (intinterval PGNSP PGUID 12 f f t f i 2 16 "702 704" intinterval - _null_ ));
520520DESCR ("abstime in tinterval" );
521521DATA (insert OID = 249 (tintervalrel PGNSP PGUID 12 f f t f i 1 703 "704" tintervalrel - _null_ ));
522- DESCR ("" );
522+ DESCR ("tinterval to reltime " );
523523DATA (insert OID = 250 (timenow PGNSP PGUID 12 f f t f s 0 702 "" timenow - _null_ ));
524524DESCR ("Current date and time (abstime)" );
525525DATA (insert OID = 251 (abstimeeq PGNSP PGUID 12 f f t f i 2 16 "702 702" abstimeeq - _null_ ));
@@ -547,7 +547,7 @@ DESCR("less-than-or-equal");
547547DATA (insert OID = 262 (reltimege PGNSP PGUID 12 f f t f i 2 16 "703 703" reltimege - _null_ ));
548548DESCR ("greater-than-or-equal" );
549549DATA (insert OID = 263 (tintervalsame PGNSP PGUID 12 f f t f i 2 16 "704 704" tintervalsame - _null_ ));
550- DESCR ("same as" );
550+ DESCR ("same as? " );
551551DATA (insert OID = 264 (tintervalct PGNSP PGUID 12 f f t f i 2 16 "704 704" tintervalct - _null_ ));
552552DESCR ("less-than" );
553553DATA (insert OID = 265 (tintervalov PGNSP PGUID 12 f f t f i 2 16 "704 704" tintervalov - _null_ ));
@@ -567,19 +567,19 @@ DESCR("length greater-than-or-equal");
567567DATA (insert OID = 272 (tintervalstart PGNSP PGUID 12 f f t f i 1 702 "704" tintervalstart - _null_ ));
568568DESCR ("start of interval" );
569569DATA (insert OID = 273 (tintervalend PGNSP PGUID 12 f f t f i 1 702 "704" tintervalend - _null_ ));
570- DESCR ("" );
570+ DESCR ("end of interval " );
571571DATA (insert OID = 274 (timeofday PGNSP PGUID 12 f f t f v 0 25 "" timeofday - _null_ ));
572572DESCR ("Current date and time - increments during transactions" );
573573DATA (insert OID = 275 (isfinite PGNSP PGUID 12 f f t f i 1 16 "702" abstime_finite - _null_ ));
574- DESCR ("" );
574+ DESCR ("finite abstime? " );
575575
576576DATA (insert OID = 276 (int2fac PGNSP PGUID 12 f f t f i 1 23 "21" int2fac - _null_ ));
577577DESCR ("factorial" );
578578
579579DATA (insert OID = 277 (inter_sl PGNSP PGUID 12 f f t f i 2 16 "601 628" inter_sl - _null_ ));
580- DESCR ("" );
580+ DESCR ("intersect? " );
581581DATA (insert OID = 278 (inter_lb PGNSP PGUID 12 f f t f i 2 16 "628 603" inter_lb - _null_ ));
582- DESCR ("" );
582+ DESCR ("intersect? " );
583583
584584DATA (insert OID = 279 (float48mul PGNSP PGUID 12 f f t f i 2 701 "700 701" float48mul - _null_ ));
585585DESCR ("multiply" );
@@ -716,19 +716,19 @@ DATA(insert OID = 1268 ( btcostestimate PGNSP PGUID 12 f f t f v 8 2278 "2281
716716DESCR ("btree(internal)" );
717717
718718DATA (insert OID = 339 (poly_same PGNSP PGUID 12 f f t f i 2 16 "604 604" poly_same - _null_ ));
719- DESCR ("same as" );
719+ DESCR ("same as? " );
720720DATA (insert OID = 340 (poly_contain PGNSP PGUID 12 f f t f i 2 16 "604 604" poly_contain - _null_ ));
721- DESCR ("contains" );
721+ DESCR ("contains? " );
722722DATA (insert OID = 341 (poly_left PGNSP PGUID 12 f f t f i 2 16 "604 604" poly_left - _null_ ));
723723DESCR ("is left of" );
724724DATA (insert OID = 342 (poly_overleft PGNSP PGUID 12 f f t f i 2 16 "604 604" poly_overleft - _null_ ));
725- DESCR ("overlaps, but does not extend to right of" );
725+ DESCR ("overlaps or is left of" );
726726DATA (insert OID = 343 (poly_overright PGNSP PGUID 12 f f t f i 2 16 "604 604" poly_overright - _null_ ));
727- DESCR ("overlaps, but does not extend to left of" );
727+ DESCR ("overlaps or is right of" );
728728DATA (insert OID = 344 (poly_right PGNSP PGUID 12 f f t f i 2 16 "604 604" poly_right - _null_ ));
729729DESCR ("is right of" );
730730DATA (insert OID = 345 (poly_contained PGNSP PGUID 12 f f t f i 2 16 "604 604" poly_contained - _null_ ));
731- DESCR ("contained in" );
731+ DESCR ("contained in? " );
732732DATA (insert OID = 346 (poly_overlap PGNSP PGUID 12 f f t f i 2 16 "604 604" poly_overlap - _null_ ));
733733DESCR ("overlaps" );
734734DATA (insert OID = 347 (poly_in PGNSP PGUID 12 f f t f i 1 604 "2275" poly_in - _null_ ));
@@ -762,7 +762,7 @@ DESCR("btree less-equal-greater");
762762DATA (insert OID = 361 (lseg_distance PGNSP PGUID 12 f f t f i 2 701 "601 601" lseg_distance - _null_ ));
763763DESCR ("distance between" );
764764DATA (insert OID = 362 (lseg_interpt PGNSP PGUID 12 f f t f i 2 600 "601 601" lseg_interpt - _null_ ));
765- DESCR ("" );
765+ DESCR ("intersection point " );
766766DATA (insert OID = 363 (dist_ps PGNSP PGUID 12 f f t f i 2 701 "600 601" dist_ps - _null_ ));
767767DESCR ("distance between" );
768768DATA (insert OID = 364 (dist_pb PGNSP PGUID 12 f f t f i 2 701 "600 603" dist_pb - _null_ ));
@@ -776,15 +776,15 @@ DESCR("closest point on box");
776776DATA (insert OID = 368 (close_sb PGNSP PGUID 12 f f t f i 2 600 "601 603" close_sb - _null_ ));
777777DESCR ("closest point to line segment on box" );
778778DATA (insert OID = 369 (on_ps PGNSP PGUID 12 f f t f i 2 16 "600 601" on_ps - _null_ ));
779- DESCR ("point contained in segment" );
779+ DESCR ("point contained in segment? " );
780780DATA (insert OID = 370 (path_distance PGNSP PGUID 12 f f t f i 2 701 "602 602" path_distance - _null_ ));
781781DESCR ("distance between paths" );
782782DATA (insert OID = 371 (dist_ppath PGNSP PGUID 12 f f t f i 2 701 "600 602" dist_ppath - _null_ ));
783783DESCR ("distance between point and path" );
784784DATA (insert OID = 372 (on_sb PGNSP PGUID 12 f f t f i 2 16 "601 603" on_sb - _null_ ));
785- DESCR ("contained in" );
785+ DESCR ("lseg contained in box? " );
786786DATA (insert OID = 373 (inter_sb PGNSP PGUID 12 f f t f i 2 16 "601 603" inter_sb - _null_ ));
787- DESCR ("intersects ?" );
787+ DESCR ("intersect ?" );
788788
789789/* OIDS 400 - 499 */
790790
@@ -1218,7 +1218,7 @@ DATA(insert OID = 964 ( lo_unlink PGNSP PGUID 12 f f t f v 1 23 "26"lo_un
12181218DESCR ("large object unlink(delete)" );
12191219
12201220DATA (insert OID = 973 (path_inter PGNSP PGUID 12 f f t f i 2 16 "602 602" path_inter - _null_ ));
1221- DESCR ("paths intersect?" );
1221+ DESCR ("intersect?" );
12221222DATA (insert OID = 975 (area PGNSP PGUID 12 f f t f i 1 701 "603" box_area - _null_ ));
12231223DESCR ("box area" );
12241224DATA (insert OID = 976 (width PGNSP PGUID 12 f f t f i 1 701 "603" box_width - _null_ ));
@@ -1242,7 +1242,7 @@ DESCR("less-than-or-equal");
12421242DATA (insert OID = 986 (path_n_ge PGNSP PGUID 12 f f t f i 2 16 "602 602" path_n_ge - _null_ ));
12431243DESCR ("greater-than-or-equal" );
12441244DATA (insert OID = 987 (path_length PGNSP PGUID 12 f f t f i 1 701 "602" path_length - _null_ ));
1245- DESCR ("sum of pathsegments " );
1245+ DESCR ("sum of pathsegment lengths " );
12461246DATA (insert OID = 988 (point_ne PGNSP PGUID 12 f f t f i 2 16 "600 600" point_ne - _null_ ));
12471247DESCR ("not equal" );
12481248DATA (insert OID = 989 (point_vert PGNSP PGUID 12 f f t f i 2 16 "600 600" point_vert - _null_ ));
@@ -1733,9 +1733,9 @@ DATA(insert OID = 1388 ( timetz PGNSP PGUID 12 f f t f s 1 1266 "1184" time
17331733DESCR ("convert timestamptz to timetz" );
17341734
17351735DATA (insert OID = 1389 (isfinite PGNSP PGUID 12 f f t f i 1 16 "1184" timestamp_finite - _null_ ));
1736- DESCR ("boolean test " );
1736+ DESCR ("finite timestamp? " );
17371737DATA (insert OID = 1390 (isfinite PGNSP PGUID 12 f f t f i 1 16 "1186" interval_finite - _null_ ));
1738- DESCR ("boolean test " );
1738+ DESCR ("finite interval? " );
17391739
17401740
17411741DATA (insert OID = 1391 (factorial PGNSP PGUID 12 f f t f i 1 23 "21" int2fac - _null_ ));
@@ -1785,13 +1785,13 @@ DESCR("vertical?");
17851785DATA (insert OID = 1411 (ishorizontal PGNSP PGUID 12 f f t f i 1 16 "601" lseg_horizontal - _null_ ));
17861786DESCR ("horizontal?" );
17871787DATA (insert OID = 1412 (isparallel PGNSP PGUID 12 f f t f i 2 16 "628 628" line_parallel - _null_ ));
1788- DESCR ("lines parallel?" );
1788+ DESCR ("parallel?" );
17891789DATA (insert OID = 1413 (isperp PGNSP PGUID 12 f f t f i 2 16 "628 628" line_perp - _null_ ));
1790- DESCR ("lines perpendicular?" );
1790+ DESCR ("perpendicular?" );
17911791DATA (insert OID = 1414 (isvertical PGNSP PGUID 12 f f t f i 1 16 "628" line_vertical - _null_ ));
1792- DESCR ("lines vertical?" );
1792+ DESCR ("vertical?" );
17931793DATA (insert OID = 1415 (ishorizontal PGNSP PGUID 12 f f t f i 1 16 "628" line_horizontal - _null_ ));
1794- DESCR ("lines horizontal?" );
1794+ DESCR ("horizontal?" );
17951795DATA (insert OID = 1416 (point PGNSP PGUID 12 f f t f i 1 600 "718" circle_center - _null_ ));
17961796DESCR ("center of" );
17971797
@@ -1818,14 +1818,14 @@ DESCR("path contains point?");
18181818DATA (insert OID = 1428 (poly_contain_pt PGNSP PGUID 12 f f t f i 2 16 "604 600" poly_contain_pt - _null_ ));
18191819DESCR ("polygon contains point?" );
18201820DATA (insert OID = 1429 (pt_contained_poly PGNSP PGUID 12 f f t f i 2 16 "600 604" pt_contained_poly - _null_ ));
1821- DESCR ("point containedby polygon?" );
1821+ DESCR ("point containedin polygon?" );
18221822
18231823DATA (insert OID = 1430 (isclosed PGNSP PGUID 12 f f t f i 1 16 "602" path_isclosed - _null_ ));
18241824DESCR ("path closed?" );
18251825DATA (insert OID = 1431 (isopen PGNSP PGUID 12 f f t f i 1 16 "602" path_isopen - _null_ ));
18261826DESCR ("path open?" );
18271827DATA (insert OID = 1432 (path_npoints PGNSP PGUID 12 f f t f i 1 23 "602" path_npoints - _null_ ));
1828- DESCR ("# points in path" );
1828+ DESCR ("number of points in path" );
18291829
18301830/* pclose and popen might better be named close and open, but that crashes initdb.
18311831 * - thomas 97/04/20
@@ -1873,19 +1873,19 @@ DESCR("(internal)");
18731873DATA (insert OID = 1451 (circle_out PGNSP PGUID 12 f f t f i 1 2275 "718" circle_out - _null_ ));
18741874DESCR ("(internal)" );
18751875DATA (insert OID = 1452 (circle_same PGNSP PGUID 12 f f t f i 2 16 "718 718" circle_same - _null_ ));
1876- DESCR ("same as" );
1876+ DESCR ("same as? " );
18771877DATA (insert OID = 1453 (circle_contain PGNSP PGUID 12 f f t f i 2 16 "718 718" circle_contain - _null_ ));
1878- DESCR ("contains" );
1878+ DESCR ("contains? " );
18791879DATA (insert OID = 1454 (circle_left PGNSP PGUID 12 f f t f i 2 16 "718 718" circle_left - _null_ ));
18801880DESCR ("is left of" );
18811881DATA (insert OID = 1455 (circle_overleft PGNSP PGUID 12 f f t f i 2 16 "718 718" circle_overleft - _null_ ));
1882- DESCR ("overlaps, but does not extend to right of" );
1882+ DESCR ("overlaps or is left of" );
18831883DATA (insert OID = 1456 (circle_overright PGNSP PGUID 12 f f t f i 2 16 "718 718" circle_overright - _null_ ));
1884- DESCR ("" );
1884+ DESCR ("overlaps or is right of " );
18851885DATA (insert OID = 1457 (circle_right PGNSP PGUID 12 f f t f i 2 16 "718 718" circle_right - _null_ ));
18861886DESCR ("is right of" );
18871887DATA (insert OID = 1458 (circle_contained PGNSP PGUID 12 f f t f i 2 16 "718 718" circle_contained - _null_ ));
1888- DESCR ("" );
1888+ DESCR ("contained in? " );
18891889DATA (insert OID = 1459 (circle_overlap PGNSP PGUID 12 f f t f i 2 16 "718 718" circle_overlap - _null_ ));
18901890DESCR ("overlaps" );
18911891DATA (insert OID = 1460 (circle_below PGNSP PGUID 12 f f t f i 2 16 "718 718" circle_below - _null_ ));
@@ -1961,15 +1961,15 @@ DESCR("line from points");
19611961DATA (insert OID = 1494 (line_interpt PGNSP PGUID 12 f f t f i 2 600 "628 628" line_interpt - _null_ ));
19621962DESCR ("intersection point" );
19631963DATA (insert OID = 1495 (line_intersect PGNSP PGUID 12 f f t f i 2 16 "628 628" line_intersect - _null_ ));
1964- DESCR ("lines intersect?" );
1964+ DESCR ("intersect?" );
19651965DATA (insert OID = 1496 (line_parallel PGNSP PGUID 12 f f t f i 2 16 "628 628" line_parallel - _null_ ));
1966- DESCR ("lines parallel?" );
1966+ DESCR ("parallel?" );
19671967DATA (insert OID = 1497 (line_perp PGNSP PGUID 12 f f t f i 2 16 "628 628" line_perp - _null_ ));
1968- DESCR ("lines perpendicular?" );
1968+ DESCR ("perpendicular?" );
19691969DATA (insert OID = 1498 (line_vertical PGNSP PGUID 12 f f t f i 1 16 "628" line_vertical - _null_ ));
1970- DESCR ("lines vertical?" );
1970+ DESCR ("vertical?" );
19711971DATA (insert OID = 1499 (line_horizontal PGNSP PGUID 12 f f t f i 1 16 "628" line_horizontal - _null_ ));
1972- DESCR ("lines horizontal?" );
1972+ DESCR ("horizontal?" );
19731973
19741974/* OIDS 1500 - 1599 */
19751975
@@ -1996,7 +1996,7 @@ DESCR("center of");
19961996DATA (insert OID = 1544 (polygon PGNSP PGUID 14 f f t f i 1 604 "718" "select polygon(12, $1)" - _null_ ));
19971997DESCR ("convert circle to 12-vertex polygon" );
19981998DATA (insert OID = 1545 (npoints PGNSP PGUID 12 f f t f i 1 23 "602" path_npoints - _null_ ));
1999- DESCR ("# points in path" );
1999+ DESCR ("number of points in path" );
20002000DATA (insert OID = 1556 (npoints PGNSP PGUID 12 f f t f i 1 23 "604" poly_npoints - _null_ ));
20012001DESCR ("number of points in polygon" );
20022002
@@ -2867,7 +2867,7 @@ DESCR("convert time with time zone to time");
28672867DATA (insert OID = 2047 (timetz PGNSP PGUID 12 f f t f s 1 1266 "1083" time_timetz - _null_ ));
28682868DESCR ("convert time to timetz" );
28692869DATA (insert OID = 2048 (isfinite PGNSP PGUID 12 f f t f i 1 16 "1114" timestamp_finite - _null_ ));
2870- DESCR ("boolean test " );
2870+ DESCR ("finite timestamp? " );
28712871DATA (insert OID = 2049 (to_char PGNSP PGUID 12 f f t f s 2 25 "1114 25" timestamp_to_char - _null_ ));
28722872DESCR ("format timestamp to text" );
28732873DATA (insert OID = 2050 (interval_mi_time PGNSP PGUID 14 f f t f i 2 1083 "1186 1083" "select $2 - $1" - _null_ ));