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.
Search WWH ::




Custom Search