|
7 | 7 | * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group |
8 | 8 | * Portions Copyright (c) 1994, Regents of the University of California |
9 | 9 | * |
10 | | - * $Id: pg_proc.h,v 1.286 2003/03/10 22:28:20 tgl Exp $ |
| 10 | + * $Id: pg_proc.h,v 1.287 2003/03/14 04:43:52 tgl Exp $ |
11 | 11 | * |
12 | 12 | * NOTES |
13 | 13 | * The script catalog/genbki.sh reads this file and generates .bki |
@@ -1283,8 +1283,8 @@ DESCR("convert timetz to text"); |
1283 | 1283 |
|
1284 | 1284 | /* OIDS 1000 - 1999 */ |
1285 | 1285 |
|
1286 | | -DATA(insertOID=1026 (timezonePGNSPPGUID12fftfs21186"1186 1184"timestamptz_izone-_null_ )); |
1287 | | -DESCR("time zone"); |
| 1286 | +DATA(insertOID=1026 (timezonePGNSPPGUID12fftfs21114"1186 1184"timestamptz_izone-_null_ )); |
| 1287 | +DESCR("adjust timestamp to newtime zone"); |
1288 | 1288 |
|
1289 | 1289 | DATA(insertOID=1029 (nullvaluePGNSPPGUID12ffffi116"2276"nullvalue-_null_ )); |
1290 | 1290 | DESCR("(internal)"); |
@@ -1418,7 +1418,7 @@ DESCR("greater-than-or-equal"); |
1418 | 1418 | DATA(insertOID=1157 (timestamptz_gtPGNSPPGUID12fftfi216"1184 1184"timestamp_gt-_null_ )); |
1419 | 1419 | DESCR("greater-than"); |
1420 | 1420 | DATA(insertOID=1159 (timezonePGNSPPGUID12fftfs21114"25 1184"timestamptz_zone-_null_ )); |
1421 | | -DESCR("timestampat a specified time zone"); |
| 1421 | +DESCR("adjusttimestampto new time zone"); |
1422 | 1422 |
|
1423 | 1423 | DATA(insertOID=1160 (interval_inPGNSPPGUID12fftfs31186"2275 26 23"interval_in-_null_ )); |
1424 | 1424 | DESCR("(internal)"); |
@@ -2849,9 +2849,9 @@ DESCR("smaller of two"); |
2849 | 2849 | DATA(insertOID=2036 (timestamp_largerPGNSPPGUID12fftfi21114"1114 1114"timestamp_larger-_null_ )); |
2850 | 2850 | DESCR("larger of two"); |
2851 | 2851 | DATA(insertOID=2037 (timezonePGNSPPGUID12fftfs21266"25 1266"timetz_zone-_null_ )); |
2852 | | -DESCR("time with time zone"); |
| 2852 | +DESCR("adjusttime with time zone to new zone"); |
2853 | 2853 | DATA(insertOID=2038 (timezonePGNSPPGUID12fftfi21266"1186 1266"timetz_izone-_null_ )); |
2854 | | -DESCR("time with time zone"); |
| 2854 | +DESCR("adjusttime with time zone to new zone"); |
2855 | 2855 | DATA(insertOID=2041 (overlapsPGNSPPGUID12ffffi416"1114 1114 1114 1114"overlaps_timestamp-_null_ )); |
2856 | 2856 | DESCR("SQL92 interval comparison"); |
2857 | 2857 | DATA(insertOID=2042 (overlapsPGNSPPGUID14ffffi416"1114 1186 1114 1186""select ($1, ($1 + $2)) overlaps ($3, ($3 + $4))"-_null_ )); |
@@ -2892,9 +2892,9 @@ DATA(insert OID = 2059 ( agePGNSP PGUID 14 f f t f s 1 1186 "1114""select |
2892 | 2892 | DESCR("date difference from today preserving months and years"); |
2893 | 2893 |
|
2894 | 2894 | DATA(insertOID=2069 (timezonePGNSPPGUID12fftfs21184"25 1114"timestamp_zone-_null_ )); |
2895 | | -DESCR("timestampat a specified time zone"); |
| 2895 | +DESCR("adjusttimestampto new time zone"); |
2896 | 2896 | DATA(insertOID=2070 (timezonePGNSPPGUID12fftfs21184"1186 1114"timestamp_izone-_null_ )); |
2897 | | -DESCR("time zone"); |
| 2897 | +DESCR("adjust timestamp to newtime zone"); |
2898 | 2898 | DATA(insertOID=2071 (date_pl_intervalPGNSPPGUID14fftfi21114"1082 1186""select cast($1 as timestamp without time zone) + $2;"-_null_ )); |
2899 | 2899 | DESCR("add"); |
2900 | 2900 | DATA(insertOID=2072 (date_mi_intervalPGNSPPGUID14fftfi21114"1082 1186""select cast($1 as timestamp without time zone) - $2;"-_null_ )); |
|