Forum: articles
Monitor Forum | 
Start New Thread
| RE: Npgsql:Error reading array with {NULL} [ reply ] By: Gregory Kramida on 2012-04-13 17:15 | [forum:1016052] |
|
Hi, Almost a year has past and I've encountered the very same problem. I'm trying to read integer[] arrays which may contain NULL values. The truth is, any array type in PostgreSQL should be interpreted as nullable primitive in C#, i.e. postgres integer[] should really yield int?[], not int[] for .NET or Mono. Another problem, although similar: "char"[] arrays get returned as arrays of string[], where "NULL" would be one example of a value, and empty string "" would be another. This probably should be cast to char?[] array instead. |
|
| Npgsql:Error reading array with {NULL} [ reply ] By: Michal Svoboda on 2011-06-10 13:33 | [forum:1014588] |
|
My SELECT returns data arrays in all columns NpgsqlDataReader throw exception in case that array contain some NULL value. Exception:At least one element in the source array could not be cast down to the destination array type. Please help me? Any idea? |
|
