[postgis-devel] postgis_letters in project tree?

Paul Ramsey pramsey at cleverelephant.ca
Thu Jan 27 11:06:25 PST 2022


Yeah, its just a huge case statement so for more characters add more lines to the case statement.
P

> On Jan 27, 2022, at 11:05 AM, Bruce Rindahl <bruce.rindahl at gmail.com> wrote:
> 
> Just curious, can the function be easily altered to change the twkb to say a cyrillic font if you have the data?  If so, that would be great.
> 
> On Thu, 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
> 
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel
> _______________________________________________
> 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