Skip to content

Instantly share code, notes, and snippets.

@bowguy
bowguy / postgis_word.sql
Last active February 2, 2022 17:57
postgis_word
CREATE OR REPLACE FUNCTION ST_GeomFromWord(word text, font json DEFAULT NULL)
RETURNS geometry
LANGUAGE 'plpgsql'
AS
$$
DECLARE
letters text[];
letter text;
geom geometry;
prevgeom geometry = NULL;