On 15th of December, Heikki Linnakangas committed patch:

Add point <-> polygon distance operator. Alexander Korotkov, reviewed by Emre Hasegeli.

Continue reading Waiting for 9.5 – Add point <-> polygon distance operator.

Skip to content
# Tag: distance

## Waiting for 9.5 – Add point <-> polygon distance operator.

## How to get shortest connection between two cities

On 15th of December, Heikki Linnakangas committed patch:

Add point <-> polygon distance operator. Alexander Korotkov, reviewed by Emre Hasegeli.

Continue reading Waiting for 9.5 – Add point <-> polygon distance operator.

Yesterday, on #postgresql on irc some guy asked:

22:28 < rafasc> i am trying to use plpgsql to find the shortest path between two cities, each pair of cities has one or more edges, each edge has a different wheight. 22:28 < rafasc> Is there a easy way to compute the shortest path between two cities?

Well, I was not really in a mood to solve it, so I just told him to try with recursive queries, and went on my way.

But I thought about it. And decided to see if I can write the query.

Continue reading How to get shortest connection between two cities