{"Entry":{"collection":"opclass","key":"class-btree-timestamp_ops","name":"btree/timestamp_ops (class)","aliases":["timestamp_ops","btree/timestamp_ops"],"metadata":{"aliases":["timestamp_ops","btree/timestamp_ops"],"category":"B-tree classes","content_hash":"6cfcf6551b1acb321046748fe18968e39150aa3a7ebf3e3b7d1c39337d86f65d","imported_at":"2026-09-30T00:40:38.374405+08:00","name":"btree/timestamp_ops (class)","name_zh":"","slug":"class-btree-timestamp_ops","summary":"B-tree operator class for timestamp; member of datetime_ops."}},"Definition":{"Collection":"opclass","Key":"class-btree-timestamp_ops","SourceDatabase":"center","Version":"18","SourceTable":"operator_class","SourceKey":"class-btree-timestamp_ops","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"aliases":["timestamp_ops","btree/timestamp_ops"],"class":{"default":"t","family":"datetime_ops","input_type":"timestamp","key_type":"none","method":"btree","name":"timestamp_ops"},"classes":[{"default":"t","family":"datetime_ops","family_slug":"family-btree-datetime_ops","input_type":"date","key_type":"none","method":"btree","name":"date_ops","slug":"class-btree-date_ops","source_oid":"3122"},{"default":"t","family":"datetime_ops","family_slug":"family-btree-datetime_ops","input_type":"timestamptz","key_type":"none","method":"btree","name":"timestamptz_ops","slug":"class-btree-timestamptz_ops","source_oid":"3127"},{"default":"t","family":"datetime_ops","family_slug":"family-btree-datetime_ops","input_type":"timestamp","key_type":"none","method":"btree","name":"timestamp_ops","slug":"class-btree-timestamp_ops","source_oid":"3128"}],"comparison_data":{"attributes":{"default":"t","family":"datetime_ops","input_type":"timestamp","key_type":"none","method":"btree","name":"timestamp_ops"},"classes":[{"default":"t","family":"datetime_ops","input_type":"date","key_type":"none","method":"btree","name":"date_ops"},{"default":"t","family":"datetime_ops","input_type":"timestamp","key_type":"none","method":"btree","name":"timestamp_ops"},{"default":"t","family":"datetime_ops","input_type":"timestamptz","key_type":"none","method":"btree","name":"timestamptz_ops"}],"kind":"class","operators":[{"family":"datetime_ops","left_type":"date","method":"btree","operator":"\u003c(date,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"1"},{"family":"datetime_ops","left_type":"date","method":"btree","operator":"\u003c=(date,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"2"},{"family":"datetime_ops","left_type":"date","method":"btree","operator":"=(date,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"3"},{"family":"datetime_ops","left_type":"date","method":"btree","operator":"\u003e=(date,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"4"},{"family":"datetime_ops","left_type":"date","method":"btree","operator":"\u003e(date,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"5"},{"family":"datetime_ops","left_type":"date","method":"btree","operator":"\u003c(date,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"1"},{"family":"datetime_ops","left_type":"date","method":"btree","operator":"\u003c=(date,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"2"},{"family":"datetime_ops","left_type":"date","method":"btree","operator":"=(date,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"3"},{"family":"datetime_ops","left_type":"date","method":"btree","operator":"\u003e=(date,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"4"},{"family":"datetime_ops","left_type":"date","method":"btree","operator":"\u003e(date,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"5"},{"family":"datetime_ops","left_type":"date","method":"btree","operator":"\u003c(date,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"1"},{"family":"datetime_ops","left_type":"date","method":"btree","operator":"\u003c=(date,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"2"},{"family":"datetime_ops","left_type":"date","method":"btree","operator":"=(date,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"3"},{"family":"datetime_ops","left_type":"date","method":"btree","operator":"\u003e=(date,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"4"},{"family":"datetime_ops","left_type":"date","method":"btree","operator":"\u003e(date,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"5"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003c(timestamp,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"1"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003c=(timestamp,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"2"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"=(timestamp,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"3"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003e=(timestamp,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"4"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003e(timestamp,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"5"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003c(timestamp,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"1"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003c=(timestamp,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"2"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"=(timestamp,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"3"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003e=(timestamp,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"4"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003e(timestamp,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"5"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003c(timestamp,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"1"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003c=(timestamp,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"2"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"=(timestamp,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"3"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003e=(timestamp,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"4"},{"family":"datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003e(timestamp,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"5"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003c(timestamptz,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"1"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003c=(timestamptz,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"2"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"=(timestamptz,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"3"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003e=(timestamptz,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"4"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003e(timestamptz,date)","purpose":"search","right_type":"date","sort_family":"","strategy":"5"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003c(timestamptz,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"1"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003c=(timestamptz,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"2"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"=(timestamptz,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"3"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003e=(timestamptz,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"4"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003e(timestamptz,timestamp)","purpose":"search","right_type":"timestamp","sort_family":"","strategy":"5"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003c(timestamptz,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"1"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003c=(timestamptz,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"2"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"=(timestamptz,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"3"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003e=(timestamptz,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"4"},{"family":"datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003e(timestamptz,timestamptz)","purpose":"search","right_type":"timestamptz","sort_family":"","strategy":"5"}],"support_functions":[{"family":"datetime_ops","function":"date_cmp(date,date)","left_type":"date","method":"btree","number":"1","result_type":"int4","right_type":"date"},{"family":"datetime_ops","function":"date_cmp_timestamp(date,timestamp)","left_type":"date","method":"btree","number":"1","result_type":"int4","right_type":"timestamp"},{"family":"datetime_ops","function":"date_cmp_timestamptz(date,timestamptz)","left_type":"date","method":"btree","number":"1","result_type":"int4","right_type":"timestamptz"},{"family":"datetime_ops","function":"timestamp_cmp_date(timestamp,date)","left_type":"timestamp","method":"btree","number":"1","result_type":"int4","right_type":"date"},{"family":"datetime_ops","function":"timestamp_cmp(timestamp,timestamp)","left_type":"timestamp","method":"btree","number":"1","result_type":"int4","right_type":"timestamp"},{"family":"datetime_ops","function":"timestamp_cmp_timestamptz(timestamp,timestamptz)","left_type":"timestamp","method":"btree","number":"1","result_type":"int4","right_type":"timestamptz"},{"family":"datetime_ops","function":"timestamptz_cmp_date(timestamptz,date)","left_type":"timestamptz","method":"btree","number":"1","result_type":"int4","right_type":"date"},{"family":"datetime_ops","function":"timestamptz_cmp_timestamp(timestamptz,timestamp)","left_type":"timestamptz","method":"btree","number":"1","result_type":"int4","right_type":"timestamp"},{"family":"datetime_ops","function":"timestamptz_cmp(timestamptz,timestamptz)","left_type":"timestamptz","method":"btree","number":"1","result_type":"int4","right_type":"timestamptz"},{"family":"datetime_ops","function":"date_sortsupport(internal)","left_type":"date","method":"btree","number":"2","result_type":"void","right_type":"date"},{"family":"datetime_ops","function":"timestamp_sortsupport(internal)","left_type":"timestamp","method":"btree","number":"2","result_type":"void","right_type":"timestamp"},{"family":"datetime_ops","function":"timestamp_sortsupport(internal)","left_type":"timestamptz","method":"btree","number":"2","result_type":"void","right_type":"timestamptz"},{"family":"datetime_ops","function":"in_range(date,date,interval,bool,bool)","left_type":"date","method":"btree","number":"3","result_type":"bool","right_type":"interval"},{"family":"datetime_ops","function":"in_range(timestamp,timestamp,interval,bool,bool)","left_type":"timestamp","method":"btree","number":"3","result_type":"bool","right_type":"interval"},{"family":"datetime_ops","function":"in_range(timestamptz,timestamptz,interval,bool,bool)","left_type":"timestamptz","method":"btree","number":"3","result_type":"bool","right_type":"interval"},{"family":"datetime_ops","function":"btequalimage(oid)","left_type":"date","method":"btree","number":"4","result_type":"bool","right_type":"date"},{"family":"datetime_ops","function":"btequalimage(oid)","left_type":"timestamp","method":"btree","number":"4","result_type":"bool","right_type":"timestamp"},{"family":"datetime_ops","function":"btequalimage(oid)","left_type":"timestamptz","method":"btree","number":"4","result_type":"bool","right_type":"timestamptz"},{"family":"datetime_ops","function":"date_skipsupport(internal)","left_type":"date","method":"btree","number":"6","result_type":"void","right_type":"date"},{"family":"datetime_ops","function":"timestamp_skipsupport(internal)","left_type":"timestamp","method":"btree","number":"6","result_type":"void","right_type":"timestamp"},{"family":"datetime_ops","function":"timestamp_skipsupport(internal)","left_type":"timestamptz","method":"btree","number":"6","result_type":"void","right_type":"timestamptz"}]},"comparison_hash":"1be8160dad8741f27e1753d8bf8a13a415a940acc8e8d1c9e494e82b38868a15","description":["B-tree operator class for timestamp; member of datetime_ops."],"facts":[{"label":"Object kind","value":"Operator class"},{"label":"Index AM","value":"B-tree"},{"label":"Input type","value":"timestamp"},{"label":"Stored key type","value":"Same as input type (catalog zero)"},{"label":"Default class","value":"yes"}],"operators":[{"description":"less than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"\u003c(date,date)","operator_slug":"op-3c-date-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"1"},{"description":"less than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"\u003c=(date,date)","operator_slug":"op-3c3d-date-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"2"},{"description":"equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"=(date,date)","operator_slug":"op-3d-date-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"3"},{"description":"greater than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"\u003e=(date,date)","operator_slug":"op-3e3d-date-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"4"},{"description":"greater than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"\u003e(date,date)","operator_slug":"op-3e-date-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"5"},{"description":"less than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"\u003c(date,timestamp)","operator_slug":"op-3c-date-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"1"},{"description":"less than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"\u003c=(date,timestamp)","operator_slug":"op-3c3d-date-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"2"},{"description":"equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"=(date,timestamp)","operator_slug":"op-3d-date-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"3"},{"description":"greater than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"\u003e=(date,timestamp)","operator_slug":"op-3e3d-date-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"4"},{"description":"greater than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"\u003e(date,timestamp)","operator_slug":"op-3e-date-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"5"},{"description":"less than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"\u003c(date,timestamptz)","operator_slug":"op-3c-date-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"1"},{"description":"less than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"\u003c=(date,timestamptz)","operator_slug":"op-3c3d-date-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"2"},{"description":"equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"=(date,timestamptz)","operator_slug":"op-3d-date-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"3"},{"description":"greater than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"\u003e=(date,timestamptz)","operator_slug":"op-3e3d-date-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"4"},{"description":"greater than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"date","method":"btree","operator":"\u003e(date,timestamptz)","operator_slug":"op-3e-date-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"5"},{"description":"less than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003c(timestamp,timestamp)","operator_slug":"op-3c-timestamp-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"1"},{"description":"less than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003c=(timestamp,timestamp)","operator_slug":"op-3c3d-timestamp-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"2"},{"description":"equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"=(timestamp,timestamp)","operator_slug":"op-3d-timestamp-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"3"},{"description":"greater than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003e=(timestamp,timestamp)","operator_slug":"op-3e3d-timestamp-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"4"},{"description":"greater than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003e(timestamp,timestamp)","operator_slug":"op-3e-timestamp-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"5"},{"description":"less than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003c(timestamp,date)","operator_slug":"op-3c-timestamp-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"1"},{"description":"less than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003c=(timestamp,date)","operator_slug":"op-3c3d-timestamp-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"2"},{"description":"equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"=(timestamp,date)","operator_slug":"op-3d-timestamp-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"3"},{"description":"greater than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003e=(timestamp,date)","operator_slug":"op-3e3d-timestamp-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"4"},{"description":"greater than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003e(timestamp,date)","operator_slug":"op-3e-timestamp-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"5"},{"description":"less than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003c(timestamp,timestamptz)","operator_slug":"op-3c-timestamp-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"1"},{"description":"less than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003c=(timestamp,timestamptz)","operator_slug":"op-3c3d-timestamp-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"2"},{"description":"equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"=(timestamp,timestamptz)","operator_slug":"op-3d-timestamp-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"3"},{"description":"greater than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003e=(timestamp,timestamptz)","operator_slug":"op-3e3d-timestamp-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"4"},{"description":"greater than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamp","method":"btree","operator":"\u003e(timestamp,timestamptz)","operator_slug":"op-3e-timestamp-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"5"},{"description":"less than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003c(timestamptz,timestamptz)","operator_slug":"op-3c-timestamptz-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"1"},{"description":"less than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003c=(timestamptz,timestamptz)","operator_slug":"op-3c3d-timestamptz-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"2"},{"description":"equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"=(timestamptz,timestamptz)","operator_slug":"op-3d-timestamptz-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"3"},{"description":"greater than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003e=(timestamptz,timestamptz)","operator_slug":"op-3e3d-timestamptz-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"4"},{"description":"greater than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003e(timestamptz,timestamptz)","operator_slug":"op-3e-timestamptz-timestamptz","purpose":"search","result_type":"bool","right_type":"timestamptz","sort_family":"","sort_family_slug":"","strategy":"5"},{"description":"less than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003c(timestamptz,date)","operator_slug":"op-3c-timestamptz-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"1"},{"description":"less than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003c=(timestamptz,date)","operator_slug":"op-3c3d-timestamptz-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"2"},{"description":"equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"=(timestamptz,date)","operator_slug":"op-3d-timestamptz-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"3"},{"description":"greater than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003e=(timestamptz,date)","operator_slug":"op-3e3d-timestamptz-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"4"},{"description":"greater than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003e(timestamptz,date)","operator_slug":"op-3e-timestamptz-date","purpose":"search","result_type":"bool","right_type":"date","sort_family":"","sort_family_slug":"","strategy":"5"},{"description":"less than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003c(timestamptz,timestamp)","operator_slug":"op-3c-timestamptz-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"1"},{"description":"less than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003c=(timestamptz,timestamp)","operator_slug":"op-3c3d-timestamptz-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"2"},{"description":"equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"=(timestamptz,timestamp)","operator_slug":"op-3d-timestamptz-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"3"},{"description":"greater than or equal","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003e=(timestamptz,timestamp)","operator_slug":"op-3e3d-timestamptz-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"4"},{"description":"greater than","family":"datetime_ops","family_slug":"family-btree-datetime_ops","left_type":"timestamptz","method":"btree","operator":"\u003e(timestamptz,timestamp)","operator_slug":"op-3e-timestamptz-timestamp","purpose":"search","result_type":"bool","right_type":"timestamp","sort_family":"","sort_family_slug":"","strategy":"5"}],"related":[{"label":"B-tree Index AM","url":"/wiki/indexam/btree/?v=18"},{"label":"datetime_ops family","url":"/wiki/opclass/family-btree-datetime_ops/?v=18"},{"label":"timestamp data type","url":"/wiki/type/timestamp/?v=18"}],"release":{"catalog_fingerprint":"deec62e0f0c649d9d0d058ddd0b16bf41afffd569c3fd73949ff0971ce5cabd6","channel":"stable","label":"18.6","major":"18","manual_fingerprint":"fefce9e478eb2afe5e17e869492bbedc67dce23d317f0a5257240113d6496ebc","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[{"paragraphs":["An index definition can specify an operator class for each column of an index.","The operator class identifies the operators to be used by the index for that column. For example, a B-tree index on the type int4 would use the int4_ops class; this operator class includes comparison functions for values of type int4 . In practice the default operator class for the column's data type is usually sufficient. The main reason for having operator classes is that for some data types, there could be more than one meaningful index behavior. For example, we might want to sort a complex-number data type either by absolute value or by real part. We could do this by defining two operator classes for the data type and then selecting the proper class when making an index. The operator class determines the basic sort ordering (which can then be modified by adding sort options COLLATE , ASC / DESC and/or NULLS FIRST / NULLS LAST ).","There are also some built-in operator classes besides the default ones:"],"title":"Operator classes and families"}],"signature":"btree/timestamp_ops","source_oid":"3128","sources":[{"label":"Matching PostgreSQL source archive","sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"label":"PostgreSQL 18 English manual: indexes-opclass.html","path":"indexes-opclass.html","sha256":"07de06abf3a2aff2a891a2789def434d9b76705e54d45ca5338dc13451ae2962","url":"/docs/18/indexes-opclass.html"},{"label":"PostgreSQL 18 English manual: catalog-pg-opclass.html","path":"catalog-pg-opclass.html","sha256":"6f131a502f81b813d447e746fc39ee28e5bdfb3ce8e8baea36a71ad0fde78c40","url":"/docs/18/catalog-pg-opclass.html"},{"label":"PostgreSQL 18 English manual: catalog-pg-amop.html","path":"catalog-pg-amop.html","sha256":"e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1","url":"/docs/18/catalog-pg-amop.html"},{"label":"PostgreSQL 18 English manual: catalog-pg-amproc.html","path":"catalog-pg-amproc.html","sha256":"0a09afbde0ba8da9899bf770b86d8301bee116057b16ebe7db0e4a7fca2e91c6","url":"/docs/18/catalog-pg-amproc.html"}],"support_functions":[{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"date_cmp(date,date)","left_type":"date","method":"btree","number":"1","result_type":"int4","right_type":"date"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"date_sortsupport(internal)","left_type":"date","method":"btree","number":"2","result_type":"void","right_type":"date"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"btequalimage(oid)","left_type":"date","method":"btree","number":"4","result_type":"bool","right_type":"date"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"date_skipsupport(internal)","left_type":"date","method":"btree","number":"6","result_type":"void","right_type":"date"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"date_cmp_timestamp(date,timestamp)","left_type":"date","method":"btree","number":"1","result_type":"int4","right_type":"timestamp"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"date_cmp_timestamptz(date,timestamptz)","left_type":"date","method":"btree","number":"1","result_type":"int4","right_type":"timestamptz"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"timestamp_cmp(timestamp,timestamp)","left_type":"timestamp","method":"btree","number":"1","result_type":"int4","right_type":"timestamp"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"timestamp_sortsupport(internal)","left_type":"timestamp","method":"btree","number":"2","result_type":"void","right_type":"timestamp"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"btequalimage(oid)","left_type":"timestamp","method":"btree","number":"4","result_type":"bool","right_type":"timestamp"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"timestamp_skipsupport(internal)","left_type":"timestamp","method":"btree","number":"6","result_type":"void","right_type":"timestamp"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"timestamp_cmp_date(timestamp,date)","left_type":"timestamp","method":"btree","number":"1","result_type":"int4","right_type":"date"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"timestamp_cmp_timestamptz(timestamp,timestamptz)","left_type":"timestamp","method":"btree","number":"1","result_type":"int4","right_type":"timestamptz"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"timestamptz_cmp(timestamptz,timestamptz)","left_type":"timestamptz","method":"btree","number":"1","result_type":"int4","right_type":"timestamptz"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"timestamp_sortsupport(internal)","left_type":"timestamptz","method":"btree","number":"2","result_type":"void","right_type":"timestamptz"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"btequalimage(oid)","left_type":"timestamptz","method":"btree","number":"4","result_type":"bool","right_type":"timestamptz"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"timestamp_skipsupport(internal)","left_type":"timestamptz","method":"btree","number":"6","result_type":"void","right_type":"timestamptz"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"timestamptz_cmp_date(timestamptz,date)","left_type":"timestamptz","method":"btree","number":"1","result_type":"int4","right_type":"date"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"timestamptz_cmp_timestamp(timestamptz,timestamp)","left_type":"timestamptz","method":"btree","number":"1","result_type":"int4","right_type":"timestamp"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"in_range(date,date,interval,bool,bool)","left_type":"date","method":"btree","number":"3","result_type":"bool","right_type":"interval"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"in_range(timestamp,timestamp,interval,bool,bool)","left_type":"timestamp","method":"btree","number":"3","result_type":"bool","right_type":"interval"},{"family":"datetime_ops","family_slug":"family-btree-datetime_ops","function":"in_range(timestamptz,timestamptz,interval,bool,bool)","left_type":"timestamptz","method":"btree","number":"3","result_type":"bool","right_type":"interval"}],"tables":[{"columns":[{"key":"operator","label":"Operator overload"},{"key":"strategy","label":"Strategy"},{"key":"purpose","label":"Purpose"},{"key":"sort_family","label":"Ordering family"},{"key":"scope","label":"Membership scope"},{"key":"description","label":"Source description"}],"key":"operators","rows":[{"description":"less than","operator":{"text":"\u003c(date,date)","url":"/wiki/operator/op-3c-date-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(date,date)","url":"/wiki/operator/op-3c3d-date-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(date,date)","url":"/wiki/operator/op-3d-date-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(date,date)","url":"/wiki/operator/op-3e3d-date-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(date,date)","url":"/wiki/operator/op-3e-date-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(date,timestamp)","url":"/wiki/operator/op-3c-date-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(date,timestamp)","url":"/wiki/operator/op-3c3d-date-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(date,timestamp)","url":"/wiki/operator/op-3d-date-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(date,timestamp)","url":"/wiki/operator/op-3e3d-date-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(date,timestamp)","url":"/wiki/operator/op-3e-date-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(date,timestamptz)","url":"/wiki/operator/op-3c-date-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(date,timestamptz)","url":"/wiki/operator/op-3c3d-date-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(date,timestamptz)","url":"/wiki/operator/op-3d-date-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(date,timestamptz)","url":"/wiki/operator/op-3e3d-date-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(date,timestamptz)","url":"/wiki/operator/op-3e-date-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(timestamp,timestamp)","url":"/wiki/operator/op-3c-timestamp-timestamp/?v=18"},"purpose":"search","scope":"Class input pair","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(timestamp,timestamp)","url":"/wiki/operator/op-3c3d-timestamp-timestamp/?v=18"},"purpose":"search","scope":"Class input pair","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(timestamp,timestamp)","url":"/wiki/operator/op-3d-timestamp-timestamp/?v=18"},"purpose":"search","scope":"Class input pair","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(timestamp,timestamp)","url":"/wiki/operator/op-3e3d-timestamp-timestamp/?v=18"},"purpose":"search","scope":"Class input pair","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(timestamp,timestamp)","url":"/wiki/operator/op-3e-timestamp-timestamp/?v=18"},"purpose":"search","scope":"Class input pair","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(timestamp,date)","url":"/wiki/operator/op-3c-timestamp-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(timestamp,date)","url":"/wiki/operator/op-3c3d-timestamp-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(timestamp,date)","url":"/wiki/operator/op-3d-timestamp-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(timestamp,date)","url":"/wiki/operator/op-3e3d-timestamp-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(timestamp,date)","url":"/wiki/operator/op-3e-timestamp-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(timestamp,timestamptz)","url":"/wiki/operator/op-3c-timestamp-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(timestamp,timestamptz)","url":"/wiki/operator/op-3c3d-timestamp-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(timestamp,timestamptz)","url":"/wiki/operator/op-3d-timestamp-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(timestamp,timestamptz)","url":"/wiki/operator/op-3e3d-timestamp-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(timestamp,timestamptz)","url":"/wiki/operator/op-3e-timestamp-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(timestamptz,timestamptz)","url":"/wiki/operator/op-3c-timestamptz-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(timestamptz,timestamptz)","url":"/wiki/operator/op-3c3d-timestamptz-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(timestamptz,timestamptz)","url":"/wiki/operator/op-3d-timestamptz-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(timestamptz,timestamptz)","url":"/wiki/operator/op-3e3d-timestamptz-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(timestamptz,timestamptz)","url":"/wiki/operator/op-3e-timestamptz-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(timestamptz,date)","url":"/wiki/operator/op-3c-timestamptz-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(timestamptz,date)","url":"/wiki/operator/op-3c3d-timestamptz-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(timestamptz,date)","url":"/wiki/operator/op-3d-timestamptz-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(timestamptz,date)","url":"/wiki/operator/op-3e3d-timestamptz-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(timestamptz,date)","url":"/wiki/operator/op-3e-timestamptz-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(timestamptz,timestamp)","url":"/wiki/operator/op-3c-timestamptz-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(timestamptz,timestamp)","url":"/wiki/operator/op-3c3d-timestamptz-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(timestamptz,timestamp)","url":"/wiki/operator/op-3d-timestamptz-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(timestamptz,timestamp)","url":"/wiki/operator/op-3e3d-timestamptz-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(timestamptz,timestamp)","url":"/wiki/operator/op-3e-timestamptz-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"}],"title":"Family operator strategies"},{"columns":[{"key":"number","label":"Support number"},{"key":"left_type","label":"Left type"},{"key":"right_type","label":"Right type"},{"key":"function","label":"Function signature"},{"key":"result_type","label":"Result type"}],"key":"support-functions","rows":[{"function":"date_cmp(date,date)","left_type":{"text":"date","url":"/wiki/type/date/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"date","url":"/wiki/type/date/?v=18"}},{"function":"date_sortsupport(internal)","left_type":{"text":"date","url":"/wiki/type/date/?v=18"},"number":"2","result_type":"void","right_type":{"text":"date","url":"/wiki/type/date/?v=18"}},{"function":"btequalimage(oid)","left_type":{"text":"date","url":"/wiki/type/date/?v=18"},"number":"4","result_type":"bool","right_type":{"text":"date","url":"/wiki/type/date/?v=18"}},{"function":"date_skipsupport(internal)","left_type":{"text":"date","url":"/wiki/type/date/?v=18"},"number":"6","result_type":"void","right_type":{"text":"date","url":"/wiki/type/date/?v=18"}},{"function":"date_cmp_timestamp(date,timestamp)","left_type":{"text":"date","url":"/wiki/type/date/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"}},{"function":"date_cmp_timestamptz(date,timestamptz)","left_type":{"text":"date","url":"/wiki/type/date/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"}},{"function":"timestamp_cmp(timestamp,timestamp)","left_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"}},{"function":"timestamp_sortsupport(internal)","left_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"number":"2","result_type":"void","right_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"}},{"function":"btequalimage(oid)","left_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"number":"4","result_type":"bool","right_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"}},{"function":"timestamp_skipsupport(internal)","left_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"number":"6","result_type":"void","right_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"}},{"function":"timestamp_cmp_date(timestamp,date)","left_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"date","url":"/wiki/type/date/?v=18"}},{"function":"timestamp_cmp_timestamptz(timestamp,timestamptz)","left_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"}},{"function":"timestamptz_cmp(timestamptz,timestamptz)","left_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"}},{"function":"timestamp_sortsupport(internal)","left_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"number":"2","result_type":"void","right_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"}},{"function":"btequalimage(oid)","left_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"number":"4","result_type":"bool","right_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"}},{"function":"timestamp_skipsupport(internal)","left_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"number":"6","result_type":"void","right_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"}},{"function":"timestamptz_cmp_date(timestamptz,date)","left_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"date","url":"/wiki/type/date/?v=18"}},{"function":"timestamptz_cmp_timestamp(timestamptz,timestamp)","left_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"}},{"function":"in_range(date,date,interval,bool,bool)","left_type":{"text":"date","url":"/wiki/type/date/?v=18"},"number":"3","result_type":"bool","right_type":{"text":"interval","url":"/wiki/type/interval/?v=18"}},{"function":"in_range(timestamp,timestamp,interval,bool,bool)","left_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"number":"3","result_type":"bool","right_type":{"text":"interval","url":"/wiki/type/interval/?v=18"}},{"function":"in_range(timestamptz,timestamptz,interval,bool,bool)","left_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"number":"3","result_type":"bool","right_type":{"text":"interval","url":"/wiki/type/interval/?v=18"}}],"title":"Family support functions"},{"columns":[{"key":"class","label":"Class"},{"key":"input_type","label":"Input type"},{"key":"key_type","label":"Key type"},{"key":"default","label":"Default"}],"key":"classes","rows":[{"class":{"text":"date_ops","url":"/wiki/opclass/class-btree-date_ops/?v=18"},"default":"yes","input_type":{"text":"date","url":"/wiki/type/date/?v=18"},"key_type":"Same as input type"},{"class":{"text":"timestamptz_ops","url":"/wiki/opclass/class-btree-timestamptz_ops/?v=18"},"default":"yes","input_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"key_type":"Same as input type"},{"class":{"text":"timestamp_ops","url":"/wiki/opclass/class-btree-timestamp_ops/?v=18"},"default":"yes","input_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"key_type":"Same as input type"}],"title":"Classes in this family"}]},"ManualEvidence":{"release":{"catalog_fingerprint":"deec62e0f0c649d9d0d058ddd0b16bf41afffd569c3fd73949ff0971ce5cabd6","channel":"stable","label":"18.6","major":"18","manual_fingerprint":"fefce9e478eb2afe5e17e869492bbedc67dce23d317f0a5257240113d6496ebc","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"label":"Matching PostgreSQL source archive","sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"label":"PostgreSQL 18 English manual: indexes-opclass.html","path":"indexes-opclass.html","sha256":"07de06abf3a2aff2a891a2789def434d9b76705e54d45ca5338dc13451ae2962","url":"/docs/18/indexes-opclass.html"},{"label":"PostgreSQL 18 English manual: catalog-pg-opclass.html","path":"catalog-pg-opclass.html","sha256":"6f131a502f81b813d447e746fc39ee28e5bdfb3ce8e8baea36a71ad0fde78c40","url":"/docs/18/catalog-pg-opclass.html"},{"label":"PostgreSQL 18 English manual: catalog-pg-amop.html","path":"catalog-pg-amop.html","sha256":"e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1","url":"/docs/18/catalog-pg-amop.html"},{"label":"PostgreSQL 18 English manual: catalog-pg-amproc.html","path":"catalog-pg-amproc.html","sha256":"0a09afbde0ba8da9899bf770b86d8301bee116057b16ebe7db0e4a7fca2e91c6","url":"/docs/18/catalog-pg-amproc.html"}]},"MeasuredEvidence":{}},"Text":{"Collection":"opclass","Key":"class-btree-timestamp_ops","SourceDatabase":"center","Version":"18","Locale":"en","Title":"btree/timestamp_ops (class)","Summary":"B-tree operator class for timestamp; member of datetime_ops.","BodyHTML":"\u003cp\u003eB-tree operator class for timestamp; member of datetime_ops.\u003c/p\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"6bb6335e04865b702c39417d0da5ee59dcfa3bb4063ab2137b7ec19958c1dc9c","Payload":{"description":["B-tree operator class for timestamp; member of datetime_ops."],"related":[{"label":"B-tree Index AM","url":"/wiki/indexam/btree/?v=18"},{"label":"datetime_ops family","url":"/wiki/opclass/family-btree-datetime_ops/?v=18"},{"label":"timestamp data type","url":"/wiki/type/timestamp/?v=18"}],"sections":[{"paragraphs":["An index definition can specify an operator class for each column of an index.","The operator class identifies the operators to be used by the index for that column. For example, a B-tree index on the type int4 would use the int4_ops class; this operator class includes comparison functions for values of type int4 . In practice the default operator class for the column's data type is usually sufficient. The main reason for having operator classes is that for some data types, there could be more than one meaningful index behavior. For example, we might want to sort a complex-number data type either by absolute value or by real part. We could do this by defining two operator classes for the data type and then selecting the proper class when making an index. The operator class determines the basic sort ordering (which can then be modified by adding sort options COLLATE , ASC / DESC and/or NULLS FIRST / NULLS LAST ).","There are also some built-in operator classes besides the default ones:"],"title":"Operator classes and families"}],"tables":[{"columns":[{"key":"operator","label":"Operator overload"},{"key":"strategy","label":"Strategy"},{"key":"purpose","label":"Purpose"},{"key":"sort_family","label":"Ordering family"},{"key":"scope","label":"Membership scope"},{"key":"description","label":"Source description"}],"key":"operators","rows":[{"description":"less than","operator":{"text":"\u003c(date,date)","url":"/wiki/operator/op-3c-date-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(date,date)","url":"/wiki/operator/op-3c3d-date-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(date,date)","url":"/wiki/operator/op-3d-date-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(date,date)","url":"/wiki/operator/op-3e3d-date-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(date,date)","url":"/wiki/operator/op-3e-date-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(date,timestamp)","url":"/wiki/operator/op-3c-date-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(date,timestamp)","url":"/wiki/operator/op-3c3d-date-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(date,timestamp)","url":"/wiki/operator/op-3d-date-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(date,timestamp)","url":"/wiki/operator/op-3e3d-date-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(date,timestamp)","url":"/wiki/operator/op-3e-date-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(date,timestamptz)","url":"/wiki/operator/op-3c-date-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(date,timestamptz)","url":"/wiki/operator/op-3c3d-date-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(date,timestamptz)","url":"/wiki/operator/op-3d-date-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(date,timestamptz)","url":"/wiki/operator/op-3e3d-date-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(date,timestamptz)","url":"/wiki/operator/op-3e-date-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(timestamp,timestamp)","url":"/wiki/operator/op-3c-timestamp-timestamp/?v=18"},"purpose":"search","scope":"Class input pair","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(timestamp,timestamp)","url":"/wiki/operator/op-3c3d-timestamp-timestamp/?v=18"},"purpose":"search","scope":"Class input pair","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(timestamp,timestamp)","url":"/wiki/operator/op-3d-timestamp-timestamp/?v=18"},"purpose":"search","scope":"Class input pair","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(timestamp,timestamp)","url":"/wiki/operator/op-3e3d-timestamp-timestamp/?v=18"},"purpose":"search","scope":"Class input pair","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(timestamp,timestamp)","url":"/wiki/operator/op-3e-timestamp-timestamp/?v=18"},"purpose":"search","scope":"Class input pair","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(timestamp,date)","url":"/wiki/operator/op-3c-timestamp-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(timestamp,date)","url":"/wiki/operator/op-3c3d-timestamp-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(timestamp,date)","url":"/wiki/operator/op-3d-timestamp-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(timestamp,date)","url":"/wiki/operator/op-3e3d-timestamp-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(timestamp,date)","url":"/wiki/operator/op-3e-timestamp-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(timestamp,timestamptz)","url":"/wiki/operator/op-3c-timestamp-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(timestamp,timestamptz)","url":"/wiki/operator/op-3c3d-timestamp-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(timestamp,timestamptz)","url":"/wiki/operator/op-3d-timestamp-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(timestamp,timestamptz)","url":"/wiki/operator/op-3e3d-timestamp-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(timestamp,timestamptz)","url":"/wiki/operator/op-3e-timestamp-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(timestamptz,timestamptz)","url":"/wiki/operator/op-3c-timestamptz-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(timestamptz,timestamptz)","url":"/wiki/operator/op-3c3d-timestamptz-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(timestamptz,timestamptz)","url":"/wiki/operator/op-3d-timestamptz-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(timestamptz,timestamptz)","url":"/wiki/operator/op-3e3d-timestamptz-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(timestamptz,timestamptz)","url":"/wiki/operator/op-3e-timestamptz-timestamptz/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(timestamptz,date)","url":"/wiki/operator/op-3c-timestamptz-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(timestamptz,date)","url":"/wiki/operator/op-3c3d-timestamptz-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(timestamptz,date)","url":"/wiki/operator/op-3d-timestamptz-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(timestamptz,date)","url":"/wiki/operator/op-3e3d-timestamptz-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(timestamptz,date)","url":"/wiki/operator/op-3e-timestamptz-date/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"},{"description":"less than","operator":{"text":"\u003c(timestamptz,timestamp)","url":"/wiki/operator/op-3c-timestamptz-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"1"},{"description":"less than or equal","operator":{"text":"\u003c=(timestamptz,timestamp)","url":"/wiki/operator/op-3c3d-timestamptz-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"2"},{"description":"equal","operator":{"text":"=(timestamptz,timestamp)","url":"/wiki/operator/op-3d-timestamptz-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"3"},{"description":"greater than or equal","operator":{"text":"\u003e=(timestamptz,timestamp)","url":"/wiki/operator/op-3e3d-timestamptz-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"4"},{"description":"greater than","operator":{"text":"\u003e(timestamptz,timestamp)","url":"/wiki/operator/op-3e-timestamptz-timestamp/?v=18"},"purpose":"search","scope":"Family member","sort_family":"","strategy":"5"}],"title":"Family operator strategies"},{"columns":[{"key":"number","label":"Support number"},{"key":"left_type","label":"Left type"},{"key":"right_type","label":"Right type"},{"key":"function","label":"Function signature"},{"key":"result_type","label":"Result type"}],"key":"support-functions","rows":[{"function":"date_cmp(date,date)","left_type":{"text":"date","url":"/wiki/type/date/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"date","url":"/wiki/type/date/?v=18"}},{"function":"date_sortsupport(internal)","left_type":{"text":"date","url":"/wiki/type/date/?v=18"},"number":"2","result_type":"void","right_type":{"text":"date","url":"/wiki/type/date/?v=18"}},{"function":"btequalimage(oid)","left_type":{"text":"date","url":"/wiki/type/date/?v=18"},"number":"4","result_type":"bool","right_type":{"text":"date","url":"/wiki/type/date/?v=18"}},{"function":"date_skipsupport(internal)","left_type":{"text":"date","url":"/wiki/type/date/?v=18"},"number":"6","result_type":"void","right_type":{"text":"date","url":"/wiki/type/date/?v=18"}},{"function":"date_cmp_timestamp(date,timestamp)","left_type":{"text":"date","url":"/wiki/type/date/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"}},{"function":"date_cmp_timestamptz(date,timestamptz)","left_type":{"text":"date","url":"/wiki/type/date/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"}},{"function":"timestamp_cmp(timestamp,timestamp)","left_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"}},{"function":"timestamp_sortsupport(internal)","left_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"number":"2","result_type":"void","right_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"}},{"function":"btequalimage(oid)","left_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"number":"4","result_type":"bool","right_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"}},{"function":"timestamp_skipsupport(internal)","left_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"number":"6","result_type":"void","right_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"}},{"function":"timestamp_cmp_date(timestamp,date)","left_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"date","url":"/wiki/type/date/?v=18"}},{"function":"timestamp_cmp_timestamptz(timestamp,timestamptz)","left_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"}},{"function":"timestamptz_cmp(timestamptz,timestamptz)","left_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"}},{"function":"timestamp_sortsupport(internal)","left_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"number":"2","result_type":"void","right_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"}},{"function":"btequalimage(oid)","left_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"number":"4","result_type":"bool","right_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"}},{"function":"timestamp_skipsupport(internal)","left_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"number":"6","result_type":"void","right_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"}},{"function":"timestamptz_cmp_date(timestamptz,date)","left_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"date","url":"/wiki/type/date/?v=18"}},{"function":"timestamptz_cmp_timestamp(timestamptz,timestamp)","left_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"number":"1","result_type":"int4","right_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"}},{"function":"in_range(date,date,interval,bool,bool)","left_type":{"text":"date","url":"/wiki/type/date/?v=18"},"number":"3","result_type":"bool","right_type":{"text":"interval","url":"/wiki/type/interval/?v=18"}},{"function":"in_range(timestamp,timestamp,interval,bool,bool)","left_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"number":"3","result_type":"bool","right_type":{"text":"interval","url":"/wiki/type/interval/?v=18"}},{"function":"in_range(timestamptz,timestamptz,interval,bool,bool)","left_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"number":"3","result_type":"bool","right_type":{"text":"interval","url":"/wiki/type/interval/?v=18"}}],"title":"Family support functions"},{"columns":[{"key":"class","label":"Class"},{"key":"input_type","label":"Input type"},{"key":"key_type","label":"Key type"},{"key":"default","label":"Default"}],"key":"classes","rows":[{"class":{"text":"date_ops","url":"/wiki/opclass/class-btree-date_ops/?v=18"},"default":"yes","input_type":{"text":"date","url":"/wiki/type/date/?v=18"},"key_type":"Same as input type"},{"class":{"text":"timestamptz_ops","url":"/wiki/opclass/class-btree-timestamptz_ops/?v=18"},"default":"yes","input_type":{"text":"timestamptz","url":"/wiki/type/timestamptz/?v=18"},"key_type":"Same as input type"},{"class":{"text":"timestamp_ops","url":"/wiki/opclass/class-btree-timestamp_ops/?v=18"},"default":"yes","input_type":{"text":"timestamp","url":"/wiki/type/timestamp/?v=18"},"key_type":"Same as input type"}],"title":"Classes in this family"}]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}