描述

傳回儲存在 tiger.geocode_settings 表格中特定設定的值。設定允許您切換函式的除錯功能。後續計畫將使用設定來控制評分。目前的設定列表如下：

              name              | setting |  unit   | category  |                                                             short_desc
--------------------------------+---------+---------+-----------+------------------------------------------------------------------------------------------------------------------------------
 debug_geocode_address          | false   | boolean | debug     | outputs debug information in notice log such as queries when geocode_address is called if true
 debug_geocode_intersection     | false   | boolean | debug     | outputs debug information in notice log such as queries when geocode_intersection is called if true
 debug_normalize_address        | false   | boolean | debug     | outputs debug information in notice log such as queries and intermediate expressions when normalize_address is called if true
 debug_reverse_geocode          | false   | boolean | debug     | if true, outputs debug information in notice log such as queries and intermediate expressions when reverse_geocode
 reverse_geocode_numbered_roads | 0       | integer | rating    | For state and county highways, 0 - no preference in name,
                                                                  1 - prefer the numbered highway name, 2 - prefer local state/county name
 use_pagc_address_parser        | false   | boolean | normalize | If set to true, will try to use the address_standardizer extension (via pagc_normalize_address)
                                                                 instead of tiger normalize_address built one    

變更：2.2.0：預設設定現在保存在一個名為 geocode_settings_default 的表格中。自訂設定位於 geocode_settings 中，且僅包含使用者設定的項目。

可用性：2.1.0

範例：傳回除錯設定

SELECT get_geocode_setting('debug_geocode_address) As result;
result
---------
false
        

另請參閱

Set_Geocode_Setting