Numeric values are parsed as strings but arrays of numerics are parsed as number arrays

[jamesopstad]

I've come across an issue where numeric values are parsed as strings but arrays of numerics are parsed as number arrays. Here is a minimal query to reproduce:

SELECT 1.11::numeric AS single_numeric, '{1.11,2.22,3.33}'::numeric[] AS numeric_array

I would expect numeric arrays to parse as string arrays.

[sehrope]

What version of pg / pg-types are you using? This should have been fixed in afead5b and there are tests in the repo for that as well:

node-pg-types/test/types.js

Lines 454 to 462 in 37606f8

	exports['array/numeric'] = {
	format: 'text',
	id: 1231,
	tests: [
	['{1.2,3.4}', function (t, value) {
	t.deepEqual(value, ['1.2', '3.4'])
	}]
	]
	}

[jamesopstad]

I am seeing this behaviour in the latest version of pg (8.11.3). Looking at its dependencies though, I see that it is using an old version of pg-types(2.1.0). Apologies, I assumed they would be updated together. Should I raise an issue in the node-postgres repo instead?

[sehrope]

Yes it needs to be updated in pg. Check if there's an existing issue as IIRC this has come up previously and if not open an issue. There's some (potentially?) breaking changes that would mandate a major version bump on the pg side to incorporate the newer version of this library but after five years it's probably time we do it.

[shivan-eyespace]

We have come across this also; with pg 2.2.0