How to write this postgresql dynamic query

Question

I have a custom spatial function and its working with this parameters (coordinates):

SELECT get_nearest_station (-80.364565, 26.070670);

Now, I want to update column "SOURCE" for all rows in a table 'employees_wgs' with this function. Coordinates are in columns X and Y for each record so I have to replace real coordinates with value from those columns.

How to write this query ? Is this need to be dynamic sql or else ?

Thanks

I would consider not to store the functionally dependent value redundantly. Create a VIEW instead. If you need to optimize performance, consider a MATERIALIZED VIEW. — Erwin Brandstetter
– Erwin Brandstetter, Commented Nov 27, 2014 at 18:48

user330315 · Accepted Answer · 2014-11-27 13:02:00Z

2

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

answered Nov 27, 2014 at 13:02

user330315

Sign up to request clarification or add additional context in comments.

1 Comment

sys49152 Over a year ago

that was fast! Thanks. I will try immidiately

Collectives™ on Stack Overflow

How to write this postgresql dynamic query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related