mORMot Open Source

ertank

Member

Registered: 2016-03-16

Posts: 163

Is it possible to parse PostgreSQL arrays?

Hi,

PostgreSQL has ability to use arrays in a field. They are something like below

{A,B,C,E}	
{F,G,H,I}	
{Ş,Ğ,İ,Ö}	
{some,text}
{more,text}
{"a test text"}

I am searching for a parser for such array values I get from database. I wonder if there is a way to parse them using mORMot framework. I might be OK to use some record definitions if I need to.

Thanks & regards,
-Ertan

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,235

Website

Re: Is it possible to parse PostgreSQL arrays?

This kind of fields is not yet supported yet at SynDB level...

But if the arrays are retrieved as text, I guess you can reuse low-level JSON functions as defined in SynCommons.pas for efficient parsing.