66 *
77 * Copyright (c) 1994, Regents of the University of California
88 *
9- * $Id: pg_proc.h,v 1.39 1997/11/30 22:52:24 thomas Exp $
9+ * $Id: pg_proc.h,v 1.40 1997/12/16 15:53:17 thomas Exp $
1010 *
1111 * NOTES
1212 * The script catalog/genbki.sh reads this file and generates .bki
@@ -213,6 +213,8 @@ DATA(insert OID = 1254 ( textregexeq PGUID 11 f t f 2 f 16 "25 25" 100 0 1 0
213213DESCR ("matches regex., case-sensitive" );
214214DATA (insert OID = 1256 (textregexne PGUID 11 f t f 2 f 16 "25 25" 100 0 1 0 foo bar ));
215215DESCR ("does not match regex., case-sensitive" );
216+ DATA (insert OID = 1257 (textlen PGUID 11 f t f 1 f 23 "25" 100 0 1 0 foo bar ));
217+ DESCR ("length" );
216218DATA (insert OID = 1258 (textcat PGUID 11 f t f 2 f 25 "25 25" 100 0 1 0 foo bar ));
217219DESCR ("concat" );
218220DATA (insert OID = 84 (boolne PGUID 11 f t f 2 f 16 "16 16" 100 0 0 100 foo bar ));
@@ -1548,7 +1550,7 @@ DATA(insert OID = 1191 ( text_datetime PGUID 11 f t f 1 f 1184 "25" 100 0 0 1
15481550DESCR ("convert" );
15491551DATA (insert OID = 1192 (datetime_text PGUID 11 f t f 1 f 25 "1184" 100 0 0 100 foo bar ));
15501552DESCR ("convert" );
1551- DATA (insert OID = 1193 (timespan_text PGUID 11 f t f 1 f 1186 "25 "100 0 0 100 foo bar ));
1553+ DATA (insert OID = 1193 (timespan_text PGUID 11 f t f 1 f 25 "1186 "100 0 0 100 foo bar ));
15521554DESCR ("convert" );
15531555DATA (insert OID = 1194 (timespan_reltime PGUID 11 f t f 1 f 703 "1186" 100 0 0 100 foo bar ));
15541556DESCR ("convert" );
@@ -1586,6 +1588,16 @@ DESCR("matches regex., case-insensitive");
15861588DATA (insert OID = 1241 (nameicregexne PGUID 11 f t f 2 f 16 "19 25" 100 0 0 100 foo bar ));
15871589DESCR ("does not match regex., case-insensitive" );
15881590
1591+ DATA (insert OID = 1251 (bpcharlen PGUID 11 f t f 1 f 23 "1042" 100 0 0 100 foo bar ));
1592+ DESCR ("octet length" );
1593+ DATA (insert OID = 1253 (varcharlen PGUID 11 f t f 1 f 23 "1043" 100 0 0 100 foo bar ));
1594+ DESCR ("octet length" );
1595+
1596+ DATA (insert OID = 1263 (text_timespan PGUID 11 f t f 1 f 1186 "25" 100 0 0 100 foo bar ));
1597+ DESCR ("convert" );
1598+ DATA (insert OID = 1271 (timespan_finite PGUID 11 f t f 1 f 16 "1186" 100 0 0 100 foo bar ));
1599+ DESCR ("boolean test" );
1600+
15891601DATA (insert OID = 1290 (char2icregexeq PGUID 11 f t f 2 f 16 "409 25" 100 0 0 100 foo bar ));
15901602DESCR ("matches regex., case-insensitive" );
15911603DATA (insert OID = 1291 (char2icregexne PGUID 11 f t f 2 f 16 "409 25" 100 0 0 100 foo bar ));
@@ -1696,6 +1708,12 @@ DATA(insert OID = 1369 ( timestamp PGUID 14 f t f 1 f 1296 "1296" 100 0 0 10
16961708DESCR ("convert" );
16971709DATA (insert OID = 1370 (timestamp PGUID 14 f t f 1 f 1296 "1184" 100 0 0 100 "select datetime_stamp($1)" - ));
16981710DESCR ("convert" );
1711+ DATA (insert OID = 1371 (length PGUID 14 f t f 1 f 23 "25" 100 0 0 100 "select textlen($1)" - ));
1712+ DESCR ("octet length" );
1713+ DATA (insert OID = 1372 (length PGUID 14 f t f 1 f 23 "1042" 100 0 0 100 "select bpcharlen($1)" - ));
1714+ DESCR ("octet length" );
1715+ DATA (insert OID = 1373 (length PGUID 14 f t f 1 f 23 "1043" 100 0 0 100 "select varcharlen($1)" - ));
1716+ DESCR ("octet length" );
16991717
17001718DATA (insert OID = 1380 (date_part PGUID 14 f t f 2 f 701 "25 1184" 100 0 0 100 "select datetime_part($1, $2)" - ));
17011719DESCR ("extract field from datetime" );
@@ -1719,11 +1737,15 @@ DATA(insert OID = 1389 ( age PGUID 14 f t f 1 f 1186 "1184" 100 0 0 100 "s
17191737DESCR ("difference between datetime and today but leave years and months unresolved" );
17201738
17211739DATA (insert OID = 1390 (isfinite PGUID 14 f t f 1 f 16 "1184" 100 0 0 100 "select datetime_finite($1)" - ));
1722- DESCR ("" );
1740+ DESCR ("boolean test " );
17231741DATA (insert OID = 1391 (isfinite PGUID 14 f t f 1 f 16 "1186" 100 0 0 100 "select timespan_finite($1)" - ));
1724- DESCR ("" );
1742+ DESCR ("boolean test " );
17251743DATA (insert OID = 1392 (isfinite PGUID 14 f t f 1 f 16 "702" 100 0 0 100 "select abstime_finite($1)" - ));
1726- DESCR ("" );
1744+ DESCR ("boolean test" );
1745+
1746+ DATA (insert OID = 1393 (timespan PGUID 14 f t f 1 f 1186 "25" 100 0 0 100 "select text_timespan($1)" - ));
1747+ DESCR ("convert" );
1748+
17271749/* reserve OIDs 1370-1399 for additional date/time conversion routines! tgl 97/04/01 */
17281750
17291751/* OIDS 1400 - 1499 */
