An empty array is erroneously returned
Posted: Mon 04 May 2009 20:21
Hello,
I have a table including :
"picts" BIGINT[] NOT NULL
another
"cc" TEXT[] NOT NULL
When there is no value, psql returns '{}'
For the picts, i get : "4919424291818982469"
The appli works for monthes without any problem.
Since i upgraded from 3.xx to 4.50, i get the problem.
To reproduce : create a table with array[] of bigint and TEXT
Put {} (no values). Fill a table : with Text you get out of bound in UTF8 conversion, with bigint[] the huge value "4919424291818982469".
Can you check this ?
I have to deliver, and i am locked.
BTW, i expected the new type PGSQLArray to simplify all of this...
BTW2 : The documentation give no clue about large_objects. I spent a day to find it by myself.
BAD !!
seb
I have a table including :
"picts" BIGINT[] NOT NULL
another
"cc" TEXT[] NOT NULL
When there is no value, psql returns '{}'
For the picts, i get : "4919424291818982469"
The appli works for monthes without any problem.
Since i upgraded from 3.xx to 4.50, i get the problem.
To reproduce : create a table with array[] of bigint and TEXT
Put {} (no values). Fill a table : with Text you get out of bound in UTF8 conversion, with bigint[] the huge value "4919424291818982469".
Can you check this ?
I have to deliver, and i am locked.
BTW, i expected the new type PGSQLArray to simplify all of this...
BTW2 : The documentation give no clue about large_objects. I spent a day to find it by myself.
BAD !!
seb