[postmodern-devel] Question on returning multi-dimensional arrays
Hello all, I'm having trouble trying to get a array result out of a database. Assume (query "create table test2 ( id integer, name text, stuff1 integer[] , stuff2 integer[][])") (query "insert into test2 values (5,'t5',array[21,78,93,24],array[[83,92],[16,27]])") If I'm at a psql command line, then select stuff2[1:2][1] from test2 where id=5; returns {{83},{16}} If I try to use postmodern, eg: (query "select stuff2[1:2][1] from test2 where id=5") I get an error message about junk in the result: junk in string "{83" [Condition of type SB-INT:SIMPLE-PARSE-ERROR] I'm likely missing something obvious. Everything is fine if I'm only trying to get a single item out of the array, but ideally I'd like to just pull the entire array out directly into a variable. Any suggestions or pointers would be appreciated. Sabra
Hi Sabra, I hadn't taken multi-dimensional arrays into account when writing the array parsing/serializing code. I've pushed an update to the git repo that should resolve your issue. Best, Marijn
participants (2)
-
Marijn Haverbeke
-
Sabra Crolleton