[PostGIS] #5851: pg18 support

[PostGIS]

#5851: pg18 support
-----------------------+---------------------------
  Reporter:  RekGRpth  |      Owner:  pramsey
      Type:  defect    |     Status:  closed
  Priority:  medium    |  Milestone:  PostGIS 3.5.3
 Component:  postgis   |    Version:  master
Resolution:  fixed     |   Keywords:
-----------------------+---------------------------
Comment (by Darafei Praliaskouski <me@…>):

 In [changeset:"b76c8ea766bf55ad15362f26f042adb9d0200431/git" b76c8ea/git]:
 {{{#!CommitTicketReference repository="git"
 revision="b76c8ea766bf55ad15362f26f042adb9d0200431"
 Fix regress_index on PostgreSQL 18

 PostgreSQL 18 can report fractional actual row counts in EXPLAIN ANALYZE.
 Accept that form and cast through numeric before comparing the selectivity
 estimate with the actual count.

 Use an escape string for the regular expression so the test remains stable
 when standard_conforming_strings is off.

 References #5851 for PostGIS 3.3

 (cherry picked from commit 8b1bb8316bab89f0433cf36ee085974b5acdeec8)

 (cherry picked from commit 56a3c6e3099d1e7da4326400779b23b8e3e7c634)

 (cherry picked from commit bdf0f1ab2ec393271eb37037f6cda8e94632e576)

 (cherry picked from commit 9b18cb4be92d5222faa253566618c915c3bf39ba)
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5851#comment:8>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.