Using PostGIS Geohash function to run through column of coordinates and dump results in new column?

Question

I'm new to databases.

How can I use the PostGIS Geohash function to run through a column of coordinates and dump results in new column?

Here is the postgis documentation on it

Here's what my data looks like:

Answer 1

Since you don't share what you're trying to do, it's hard to know if the answer will be of any use to you.

WITH coords AS (
  SELECT string_to_array(coord, ',') AS coords FROM mytable
)
SELECT ST_GeoHash(ST_SetSRID(ST_MakePoint(coords[1], coords[2]), 4326))
FROM coords;