Changes between Initial Version and Version 1 of Ticket #4826


Ignore:
Timestamp:
Jan 5, 2021, 6:37:19 PM (4 years ago)
Author:
robe
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #4826 – Description

    initial v1  
    1010
    1111One observation is that Hanover is not in the place table, but is in the cousub table.
     12
     13
     14
     15{{{
     16-- yields right answer
     17SELECT *
     18FROM geocode('1 Main St, Hanover, MA 02339',1);
     19
     20/** (1,,Main,St,,,Hanover,MA,02339,t,,) 0101000020AD1000007FB2EFD615B651C06A1D3D91020F4540      0
     21**/
     22}}}
     23
     24
     25{{{
     26-- yields wrong answer
     27SELECT *
     28FROM geocode('1 Main St, Hanover, MA',1);
     29
     30/**
     31(1,E,Main,St,,,Ware,MA,01082,t,,)       0101000020AD1000002FB5DC320F0F52C0E0E8EF375B214540      10
     32**/
     33}}}