Changeset 40 for hw

Show
Ignore:
Timestamp:
09/25/07 04:34:54 (5 years ago)
Author:
cs186
Message:

Ensure that the optimizer chooses index scan for the operator.

Location:
hw/hw2/postgresql-8.2.4/src/include
Files:
3 modified

Legend:

Unmodified
Added
Removed

  • hw/hw2/postgresql-8.2.4/src/include/catalog/pg_operator.h

    r34 r40  
    905905 
    906906/* truth predicate for near-neighbor search */ 
    907 DATA(insert OID = 2880 (  "~~"     PGNSP PGUID b f 603 603      16       0       0       0       0       0       0 box_true truesel truesel )); 
     907DATA(insert OID = 2880 (  "~~"     PGNSP PGUID b f 603 603      16       0       0       0       0       0       0 box_true zerosel zerosel )); 
    908908 
    909909/* 

  • hw/hw2/postgresql-8.2.4/src/include/catalog/pg_proc.h

    r34 r40  
    39823982DATA(insert OID = 2896 (  box_true         PGNSP PGUID 12 f f t f i 2 701 "603 603" _null_ _null_ _null_        box_true - _null_ )); 
    39833983DESCR("gist NN support"); 
    3984 DATA(insert OID = 2897 (  truesel                  PGNSP PGUID 12 f f t f s 4 701 "2281 26 2281 23" _null_ _null_ _null_        truesel - _null_ )); 
     3984DATA(insert OID = 2897 (  zerosel                  PGNSP PGUID 12 f f t f s 4 701 "2281 26 2281 23" _null_ _null_ _null_        zerosel - _null_ )); 
    39853985DESCR("gist NN support"); 
    39863986 

  • hw/hw2/postgresql-8.2.4/src/include/utils/geo_decls.h

    r39 r40  
    435435extern Datum contsel(PG_FUNCTION_ARGS); 
    436436extern Datum contjoinsel(PG_FUNCTION_ARGS); 
    437 extern Datum truesel(PG_FUNCTION_ARGS); 
     437extern Datum zerosel(PG_FUNCTION_ARGS); 
    438438 
    439439#endif   /* GEO_DECLS_H */