Reading text array from postGRESQL

[naturalmechanics]

My postGRESql contains some data as a text array column.

Column name is overview.

If I try:

auto r = result[0];
// check r["overview"] not null works
auto v = r["overview"].toString;

I get this error:

Please report if you came across this error! lbound==2.

Help please.

[denizzzka]

Wow, that's interesting! It was issued from: https://github.com/denizzzka/dpq2/blob/6d45b66d3504bce96d09f71a70878a64e7acb1e2/src/dpq2/result.d#L557

Please can you make SQL request in the form:

select overview::text

and get text representation of this cell directly from the server? So that I can understand what exactly dimensions format this overview array has?

[denizzzka]

@naturalmechanics as quck and dirty fix try to comment out this check: https://github.com/denizzzka/dpq2/blob/6d45b66d3504bce96d09f71a70878a64e7acb1e2/src/dpq2/result.d#L558

I think it is not needed at all - this field is, probably, only used internally by the server.

[denizzzka]

It has something to do with PG slices, I think: https://www.postgresql.org/docs/current/arrays.html#ARRAYS-IO

By default, the lower bound index value of an array's dimensions is set to one. To represent arrays with other lower bounds, the array subscript ranges can be specified explicitly before writing the array contents. This decoration consists of square brackets ([]) around each array dimension's lower and upper bounds, with a colon (:) delimiter character in between. The array dimension decoration is followed by an equal sign (=)

[naturalmechanics]

Wow, that's interesting! It was issued from: https://github.com/denizzzka/dpq2/blob/6d45b66d3504bce96d09f71a70878a64e7acb1e2/src/dpq2/result.d#L557

Please can you make SQL request in the form:

select overview::text

and get text representation of this cell directly from the server? So that I can understand what exactly dimensions format this overview array has?

I will do that on monday back in office. Sorry for the delay