Database Reference
In-Depth Information
bythe
$$
notation).Here,thequeryfindsthecloserplacestothecentroidofthein-
putgeometry.Thisisdoneusinganindexednearestneighborsearch(KNNindex),
a new feature available in PostGIS 2.
The
Find_PlaceNames
functionacceptsastheinputparametersasearchstringto
lookforandanoptional
num_results
parameter,whichinthiscasealsoissetto
adefaultof5ifnotprovidedbythefunctioncaller.Theoutputisa
SETOF RECORD
,
whichisreturnedafterrunningaquerythatusesthe
to_tsquery
PostgreSQLtext
searchfunction.Theresultsofthequeryaretheplacesfromthedatabasethatcon-
tain the
search_string
value in the name field.