I want to store WKT that can be quite large but I'm running into the 32K limit while storing them in object values.
create table A (id integer, wkt object);
I want to store WKT that can be quite large but I'm running into the 32K limit while storing them in object values.
create table A (id integer, wkt object);
So there is a way to store longer strings in objects:
By using ignored the entire object is not indexed, which also prohibits it from being used in other SQL parts properly (they will always do a full table scan).
However, subscripts work just fine.
For other readers: WKT can also be stored as geo_shape type as well, or used with match directly.