|
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 ));
|
|