[postgis-devel] postgis_letters in project tree?

Paul Ramsey pramsey at cleverelephant.ca
Thu Jan 27 13:38:31 PST 2022


Here's the two functions. I think putting these into the default postgis extension makes sense, they are small and then we have letter magic available for doco etc wherever we want.

https://gist.github.com/pramsey/2020ef463a8880edc7e23c56420d7df8

P

> On Jan 27, 2022, at 10:32 AM, Paul Ramsey <pramsey at cleverelephant.ca> wrote:
> 
> Using base64 encoded twkb, i can get the letters set down to a 22K function. So, I think maybe this just goes into the main postgis extension. (Assuming you're OK with my minimalist anglo no-special-font handling approach.)
> 
>> On Jan 27, 2022, at 9:29 AM, Martin Davis <mtnclimb at gmail.com> wrote:
>> 
>> 
>> On Thu, Jan 27, 2022 at 9:03 AM Paul Ramsey <pramsey at cleverelephant.ca> wrote:
>> I'm thinking of converting the letter/font table into a function with a fixed collection of letters, so that an install involves just two functions ST_GeomFromLetter(letter) and ST_GeomFromWord(text). ST_GeomFromLetter can be expanded over time to include additional letters for other language charsets. That matches the capabilities of the system to the needs.
>> 
>> That sounds like the simplest approach.  Nice to avoid needing a table.  
>> _______________________________________________
>> postgis-devel mailing list
>> postgis-devel at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-devel
> 



More information about the postgis-devel mailing list