Nearest neighbour trigger function with PostGIS
Hello fellow developers!
Recently I've started a project using supabase to practice and learn React Native and some database concepts.
Currently, I am trying to create a trigger function which looks at some geometry data and then sends a message to a client that is closest to the geometry point that is entered in a new row.
I was wondering if there are any developers here who have some experience with PostGIS and might have a couple of minutes to teach me a thing or two.
Recently I've started a project using supabase to practice and learn React Native and some database concepts.
Currently, I am trying to create a trigger function which looks at some geometry data and then sends a message to a client that is closest to the geometry point that is entered in a new row.
I was wondering if there are any developers here who have some experience with PostGIS and might have a couple of minutes to teach me a thing or two.
