array_to_json return type is string. It should be an array

[laurentdebricon]

array_to_json return type is string. It should be an array.
So now I have to do :

query.on('row', function(row) {
row.thumb = new Array(row.thumb);
[...]

[laurentdebricon]

in fact, new Array(row.thumb) doesn't work ... i am struggling how to get my postgres array column into a javascript Array, with or without using array_to_json

[laurentdebricon]

I've found this stll open issue : #10
and with the function parseArray provided in the thread, i can do what I want.

Funny part : a Postgres Array of Integer doesn't need this parseArray function.

[ryandesign]

I just spent some time realizing this as well. What I found out:

Set up a table:

CREATE TABLE IF NOT EXISTS arrtest (n integer, s varchar);
INSERT INTO arrtest VALUES (4, 'foo'), (5, 'bar'), (6, 'baz');

Program:

var pg = require('pg');
var conString = 'postgres://user:password@localhost/database';
pg.connect(conString, function(err, client) {
  client.query("SELECT 'hello' AS a,\
    ARRAY[1, 2, 3] AS b,\
    ARRAY['xx', 'yy', 'zz'] AS c,\
    ARRAY(SELECT n FROM arrtest) AS d,\
    ARRAY(SELECT s FROM arrtest) AS e;", function(err, result) {
    console.log(result.rows[0]);
    pg.end();
  });
});

Result:

{ a: 'hello',
  b: [ 1, 2, 3 ],
  c: [ 'xx', 'yy', 'zz' ],
  d: [ 4, 5, 6 ],
  e: '{foo,bar,baz}' }

As you can imagine, the result for e is surprising; everything else looks right.

[gkawamoto]

Well, I've been through this problem too. It appears that it's a problem interpreting varchar Arrays. A simple change in your select to

SELECT 'hello' AS a,
ARRAY[1, 2, 3] AS b,
ARRAY['xx', 'yy', 'zz'] AS c,
ARRAY(SELECT n FROM arrtest) AS d,
ARRAY(SELECT s::TEXT FROM arrtest) AS e;

would (temporarily) solve the problem.

[brianc]

Interesting - I'll take a look. As an aside in your initial example you use array_to_json. That will return a type JSON which node-postgres will correctly parse and turn into a javascript array. A "postgres" array of varchar is causing the problem, not array_to_json correct? The initial example was a bit incomplete.

[brianc]

I think this is fixed - a char array parser was added to https://github.com/brianc/node-pg-types/blob/master/lib/textParsers.js