sql - How to write this postgresql dynamic query -


i have custom spatial function , working parameters (coordinates):

select get_nearest_station (-80.364565, 26.070670); 

now, want update column "source" rows in table 'employees_wgs' function. coordinates in columns x , y each record have replace real coordinates value columns.

how write query ? need dynamic sql or else ?

thanks

update employees_wgs   set source = get_nearest_station(x,y); commit; 

Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -