Get_Geocode_Setting — 返回存储在 Tiger.geocode_settings 表中的特定设置的值。
text Get_Geocode_Setting(
text setting_name)
;
返回存储在 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 的表中。 使用自定义设置a位于geocode_settings中,并且仅包含用户设置的设置。
可用性:2.1.0
SELECT get_geocode_setting('debug_geocode_address) As result; result --------- false