|
7 | 7 | * |
8 | 8 | * Copyright (c) 1994, Regents of the University of California |
9 | 9 | * |
10 | | - * $Id: pg_operator.h,v 1.21 1997/11/24 13:43:22momjian Exp $ |
| 10 | + * $Id: pg_operator.h,v 1.22 1997/11/30 22:49:22thomas Exp $ |
11 | 11 | * |
12 | 12 | * NOTES |
13 | 13 | * the genbki.sh script reads this file and generates .bki |
@@ -339,7 +339,7 @@ DATA(insert OID = 665 ( "<=" PGUID 0 b t f 25 25 16 667 666 0 0 text_le |
339 | 339 | DATA(insertOID=666 (">"PGUID0btf25251666466500text_gtintltselintltjoinsel )); |
340 | 340 | DATA(insertOID=667 (">="PGUID0btf25251666566400text_geintltselintltjoinsel )); |
341 | 341 |
|
342 | | -DATA(insertOID=670 ("="PGUID0btf7017011667067100float8eqeqseleqjoinsel )); |
| 342 | +DATA(insertOID=670 ("="PGUID0btt7017011667067100float8eqeqseleqjoinsel )); |
343 | 343 | DATA(insertOID=671 ("<>"PGUID0btf7017011667167000float8neneqselneqjoinsel )); |
344 | 344 | DATA(insertOID=672 ("<"PGUID0btf7017011667467500float8ltintltselintltjoinsel )); |
345 | 345 | DATA(insertOID=673 ("<="PGUID0btf7017011667567400float8leintltselintltjoinsel )); |
@@ -497,31 +497,6 @@ DATA(insert OID = 1111 ( "<=" PGUID 0 b t f 10831083 16 1113 11120 0 time |
497 | 497 | DATA(insertOID=1112 (">"PGUID0btf10831083161110111100time_gtintltselintltjoinsel )); |
498 | 498 | DATA(insertOID=1113 (">="PGUID0btf10831083161111106500time_geintltselintltjoinsel )); |
499 | 499 |
|
500 | | -/* datetime operators */ |
501 | | -/* name, owner, prec, kind, isleft, canhash, left, right, result, com, negate, lsortop, rsortop, oprcode, operrest, oprjoin */ |
502 | | -DATA(insertOID=1320 ("="PGUID0btf11841184161320132113221322datetime_eqeqseleqjoinsel )); |
503 | | -DATA(insertOID=1321 ("<>"PGUID0btf11841184161321132000datetime_neneqselneqjoinsel )); |
504 | | -DATA(insertOID=1322 ("<"PGUID0btf11841184161325132500datetime_ltintltselintltjoinsel )); |
505 | | -DATA(insertOID=1323 ("<="PGUID0btf11841184161324132400datetime_leintltselintltjoinsel )); |
506 | | -DATA(insertOID=1324 (">"PGUID0btf11841184161323132300datetime_gtintltselintltjoinsel )); |
507 | | -DATA(insertOID=1325 (">="PGUID0btf11841184161322132200datetime_geintltselintltjoinsel )); |
508 | | - |
509 | | -DATA(insertOID=1327 ("+"PGUID0btf1184118611841327000datetime_pl_span-- )); |
510 | | -DATA(insertOID=1328 ("-"PGUID0btf1184118411860000datetime_mi-- )); |
511 | | -DATA(insertOID=1329 ("-"PGUID0btf1184118611840000datetime_mi_span-- )); |
512 | | - |
513 | | -/* timespan operators */ |
514 | | -DATA(insertOID=1330 ("="PGUID0btf11861186161330133113321332timespan_eqeqseleqjoinsel )); |
515 | | -DATA(insertOID=1331 ("<>"PGUID0btf11861186161331133000timespan_neneqselneqjoinsel )); |
516 | | -DATA(insertOID=1332 ("<"PGUID0btf11861186161335133500timespan_ltintltselintltjoinsel )); |
517 | | -DATA(insertOID=1333 ("<="PGUID0btf11861186161334133400timespan_leintltselintltjoinsel )); |
518 | | -DATA(insertOID=1334 (">"PGUID0btf11861186161333133300timespan_gtintltselintltjoinsel )); |
519 | | -DATA(insertOID=1335 (">="PGUID0btf11861186161332133200timespan_geintltselintltjoinsel )); |
520 | | - |
521 | | -DATA(insertOID=1336 ("-"PGUID0ltf0118611860000timespan_um00 )); |
522 | | -DATA(insertOID=1337 ("+"PGUID0btf1186118611861337000timespan_pl-- )); |
523 | | -DATA(insertOID=1338 ("-"PGUID0btf1186118611860000timespan_mi-- )); |
524 | | - |
525 | 500 | /* float48 operators */ |
526 | 501 | DATA(insertOID=1116 ("+"PGUID0btf7007017011116000float48pl-- )); |
527 | 502 | DATA(insertOID=1117 ("-"PGUID0btf7007017010000float48mi-- )); |
@@ -591,6 +566,31 @@ DATA(insert OID = 1303 ( ">"PGUID 0 b t f 1296 1296 16 1302 1304 0 0 timesta |
591 | 566 | DATA(insertOID=1304 ("<="PGUID0btf12961296161305130300timestampleintltselintltjoinsel )); |
592 | 567 | DATA(insertOID=1305 (">="PGUID0btf12961296161304130200timestampgeintltselintltjoinsel )); |
593 | 568 |
|
| 569 | +/* datetime operators */ |
| 570 | +/* name, owner, prec, kind, isleft, canhash, left, right, result, com, negate, lsortop, rsortop, oprcode, operrest, oprjoin */ |
| 571 | +DATA(insertOID=1320 ("="PGUID0btt11841184161320132113221322datetime_eqeqseleqjoinsel )); |
| 572 | +DATA(insertOID=1321 ("<>"PGUID0btf11841184161321132000datetime_neneqselneqjoinsel )); |
| 573 | +DATA(insertOID=1322 ("<"PGUID0btf11841184161325132500datetime_ltintltselintltjoinsel )); |
| 574 | +DATA(insertOID=1323 ("<="PGUID0btf11841184161324132400datetime_leintltselintltjoinsel )); |
| 575 | +DATA(insertOID=1324 (">"PGUID0btf11841184161323132300datetime_gtintltselintltjoinsel )); |
| 576 | +DATA(insertOID=1325 (">="PGUID0btf11841184161322132200datetime_geintltselintltjoinsel )); |
| 577 | + |
| 578 | +DATA(insertOID=1327 ("+"PGUID0btf1184118611841327000datetime_pl_span-- )); |
| 579 | +DATA(insertOID=1328 ("-"PGUID0btf1184118411860000datetime_mi-- )); |
| 580 | +DATA(insertOID=1329 ("-"PGUID0btf1184118611840000datetime_mi_span-- )); |
| 581 | + |
| 582 | +/* timespan operators */ |
| 583 | +DATA(insertOID=1330 ("="PGUID0btt11861186161330133113321332timespan_eqeqseleqjoinsel )); |
| 584 | +DATA(insertOID=1331 ("<>"PGUID0btf11861186161331133000timespan_neneqselneqjoinsel )); |
| 585 | +DATA(insertOID=1332 ("<"PGUID0btf11861186161335133500timespan_ltintltselintltjoinsel )); |
| 586 | +DATA(insertOID=1333 ("<="PGUID0btf11861186161334133400timespan_leintltselintltjoinsel )); |
| 587 | +DATA(insertOID=1334 (">"PGUID0btf11861186161333133300timespan_gtintltselintltjoinsel )); |
| 588 | +DATA(insertOID=1335 (">="PGUID0btf11861186161332133200timespan_geintltselintltjoinsel )); |
| 589 | + |
| 590 | +DATA(insertOID=1336 ("-"PGUID0ltf0118611860000timespan_um00 )); |
| 591 | +DATA(insertOID=1337 ("+"PGUID0btf1186118611861337000timespan_pl-- )); |
| 592 | +DATA(insertOID=1338 ("-"PGUID0btf1186118611860000timespan_mi-- )); |
| 593 | + |
594 | 594 | /* additional geometric operators - thomas 97/04/18 */ |
595 | 595 | DATA(insertOID=1420 ("@@"PGUID0ltf07186000000circle_center-- )); |
596 | 596 | DATA(insertOID=1500 ("="PGUID0btt718718161500150115021502circle_eqeqseleqjoinsel )); |
|