66 *
77 * Copyright (c) 1994, Regents of the University of California
88 *
9- * $Id: pg_proc.h,v 1.41 1997/12/23 19:29:15 thomas Exp $
9+ * $Id: pg_proc.h,v 1.42 1998/01/01 05:47:11 thomas Exp $
1010 *
1111 * NOTES
1212 * The script catalog/genbki.sh reads this file and generates .bki
@@ -1917,6 +1917,9 @@ DESCR("convert");
19171917DATA (insert OID = 1480 (circle_box PGUID 11 f t f 1 f 603 "718" 100 0 1 0 foo bar ));
19181918DESCR ("convert" );
19191919
1920+ DATA (insert OID = 1481 (text_substr PGUID 11 f t f 3 f 25 "25 23 23" 100 0 0 100 foo bar ));
1921+ DESCR ("return portion of string" );
1922+
19201923DATA (insert OID = 1530 (point PGUID 14 f t f 2 f 600 "601 601" 100 0 0 100 "select lseg_interpt($1, $2)" - ));
19211924DESCR ("convert" );
19221925DATA (insert OID = 1531 (point PGUID 14 f t f 1 f 600 "718" 100 0 0 100 "select circle_center($1)" - ));
@@ -2021,7 +2024,7 @@ DATA(insert OID = 875 ( ltrim PGUID 11 f t f 2 f 25 "25 25" 100 0 0 100 f
20212024DESCR ("left-pad string to length" );
20222025DATA (insert OID = 876 (rtrim PGUID 11 f t f 2 f 25 "25 25" 100 0 0 100 foo bar ));
20232026DESCR ("right-pad string to length" );
2024- DATA (insert OID = 877 (substr PGUID 11 f t f 3 f 25 "25 23 23" 100 0 0 100 foo bar ));
2027+ DATA (insert OID = 877 (substr PGUID 14 f t f 3 f 25 "25 23 23" 100 0 0 100 "select text_substr($1, $2, $3)" - ));
20252028DESCR ("return portion of string" );
20262029DATA (insert OID = 878 (translate PGUID 11 f t f 3 f 25 "25 18 18" 100 0 0 100 foo bar ));
20272030DESCR ("modify string by substring replacement" );
@@ -2033,7 +2036,7 @@ DATA(insert OID = 881 ( ltrim PGUID 14 f t f 1 f 25 "25" 100 0 0 100 "sel
20332036DESCR ("remove initial characters from string" );
20342037DATA (insert OID = 882 (rtrim PGUID 14 f t f 1 f 25 "25" 100 0 0 100 "select rtrim($1, \' \')" - ));
20352038DESCR ("remove trailing characters from string" );
2036- DATA (insert OID = 883 (substr PGUID 14 f t f 2 f 25 "25 23" 100 0 0 100 "select substr($1, $2,10000 )" - ));
2039+ DATA (insert OID = 883 (substr PGUID 14 f t f 2 f 25 "25 23" 100 0 0 100 "select substr($1, $2,-1 )" - ));
20372040DESCR ("return portion of string" );
20382041DATA (insert OID = 884 (btrim PGUID 11 f t f 2 f 25 "25 25" 100 0 0 100 foo bar ));
20392042DESCR ("trim both ends of string" );
