diff options
author | Noah Misch <noah@leadboat.com> | 2023-10-14 16:33:51 -0700 |
---|---|---|
committer | Noah Misch <noah@leadboat.com> | 2023-10-14 16:33:54 -0700 |
commit | bf1c21c4fad033414a99d6205118fbc4d75efa62 (patch) | |
tree | 53a1639d2b110cb0d8102af9d18d0a537dfd5106 /src/tutorial/funcs.c | |
parent | 06ff064842832187fce7474e866010d2764a066a (diff) | |
download | postgresql-bf1c21c4fad033414a99d6205118fbc4d75efa62.tar.gz postgresql-bf1c21c4fad033414a99d6205118fbc4d75efa62.zip |
Dissociate btequalimage() from interval_ops, ending its deduplication.
Under interval_ops, some equal values are distinguishable. One such
pair is '24:00:00' and '1 day'. With that being so, btequalimage()
breaches the documented contract for the "equalimage" btree support
function. This can cause incorrect results from index-only scans.
Users should REINDEX any btree indexes having interval-type columns.
After updating, pg_amcheck will report an error for almost all such
indexes. This fix makes interval_ops simply omit the support function,
like numeric_ops does. Back-pack to v13, where btequalimage() first
appeared. In back branches, for the benefit of old catalog content,
btequalimage() code will return false for type "interval". Going
forward, back-branch initdb will include the catalog change.
Reviewed by Peter Geoghegan.
Discussion: https://postgr.es/m/20231011013317.22.nmisch@google.com
Diffstat (limited to 'src/tutorial/funcs.c')
0 files changed, 0 insertions, 0 deletions