Changes between Version 1 and Version 7 of Ticket #5547


Ignore:
Timestamp:
Dec 4, 2023, 9:33:11 AM (7 months ago)
Author:
pramsey
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #5547

    • Property Milestone PostGIS 3.4.1 → PostGIS 3.3.6

  • Ticket #5547 – Description

    v1 v7  
    1 this uses a gist index on wkb_geometry when I pass a string, gist (wkb_geometry)
    2 
    3 SELECT fld_zone FROM s_fld_haz_ar WHERE
    4 st_intersects(st_geomfromtext('POINT(-83.113523 40.014991)', 4269), wkb_geometry)
    5 
     1This uses a gist index on wkb_geometry when I pass a string, gist (wkb_geometry)
     2{{{
     3SELECT fld_zone
     4FROM s_fld_haz_ar
     5WHERE st_intersects(
     6  st_geomfromtext('POINT(-83.113523 40.014991)', 4269),
     7  wkb_geometry)
     8}}}
    69
    710concatenating text fields to make the same string for the point, it will not use the gist index
    8 
    9 SELECT fld_zone FROM s_fld_haz_ar WHERE st_intersects(st_geomfromtext(concat('POINT(', '-83.113523', ' ', '40.014991', ')'), 4269), wkb_geometry)
    10 
     11{{{
     12SELECT fld_zone
     13FROM s_fld_haz_ar
     14WHERE st_intersects(
     15  st_geomfromtext(
     16    concat('POINT(', '-83.113523', ' ', '40.014991', ')'),
     17    4269),
     18  wkb_geometry)
     19}}}
    1120
    1221I'm using POSTGIS="3.4.0 3.4.0", i just upgraded
    … …  
    1726
    1827I work around it by creating and passing a text variable
    19 
     28{{{
    2029DECLARE p text = concat('POINT(', lon,' ', lat,')');
    2130st_intersects(st_geomfromtext(p, 4269), wkb_geometry)
    22 
     31}}}