[MapServer-users] jsonb attribute as a tileitem in mapserver

[Marcin Niemyjski]

Hello,


Because my postgres table started to get bigger with every new column, I decided to try out the jsonb type column, namely I tried using jsonb attribute as a tileitem within tileindex this way:

TILEITEM "location->>'10m'"

where jsonb looks like this:
{
  "10m": "/vsicurl/...",
  "20m": "/vsicurl/...",
  "30m": "/vsicurl/..."
}

but all I get is:
 [warn] [pid 15] mod_fcgid: stderr: msPostGISLayerGetItems(): Query error. Error executing SQL. Check server logs.

Is there any way of using jsonb as a location attribute equivalent?

Best,
Marcin
[https://res.cdn.office.net/assets/bookwithme/misc/CalendarPerson20px.png]<https://outlook.office.com/bookwithme/user/6347c7def05a478ba013ae948648789d@cloudferro.com?anonymous&ep=signature>           Book time to meet with me<https://outlook.office.com/bookwithme/user/6347c7def05a478ba013ae948648789d@cloudferro.com?anonymous&ep=signature>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20231130/8df70343/attachment.htm>