Re: Let an ordering index scan hand its ORDER BY value to the target list - Mailing list pgsql-hackers

From Greg Burd
Subject Re: Let an ordering index scan hand its ORDER BY value to the target list
Date
Msg-id lax6FVfJkp8n1lgCYoBo5FuYmpUARGPXiYAk8stcwA0hWjSmrbRtkqG5nVWT2y6u0Stn1YclbN9bzlzY4qJpC3eAP58lVlLiXV8jeSNk8Ek=@burd.me
Whole thread
In response to Let an ordering index scan hand its ORDER BY value to the target list  (Greg Burd <greg@burd.me>)
List pgsql-hackers
Hello,

Attached v2.  The only change from v1 is in the new gist regression test: two queries that print recomputed box
distancesnow run under extra_float_digits = 0, as create_index_spgist.sql already does for its KNN output.  macOS and
Windowsdiffered from Linux in the last digit of two of the 21 distances (0.5728001396647873 vs …874, 0.6099999999999997
vs…998) a libm / FMA variation in box_closept_point, not anything this patch does.  The equality check that actually
verifiesthe substituted values (same = total = 200) was already passing on every platform. 

v2 applies cleanly to current master (85adc584e2b).

best.

-greg
Attachment

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: [PATCH] pg_upgrade: add --initdb option to create the new cluster automatically
Next
From: Heikki Linnakangas
Date:
Subject: Re: [PATCH] pg_upgrade: add --initdb option to create the new cluster automatically