1109 {
1111 SPIPlanPtr plan = NULL;
1112 int i = 0;
1113 uint8_t id = 0;
1114
1115 if (arg == NULL)
1116 return 0;
1117
1119 *nodata = 0;
1120
1121
1123
1127 else
1128 *nodata = 1;
1129 }
1130
1131 else if (arg->
nodata[0][0][0] && !arg->
nodata[1][0][0]) {
1132 id = 1;
1137 else
1138 *nodata = 1;
1139 }
1140
1141 else if (!arg->
nodata[0][0][0] && arg->
nodata[1][0][0]) {
1142 id = 2;
1147 else
1148 *nodata = 1;
1149 }
1150
1151 else {
1152 id = 0;
1157 else {
1160 else
1161 *nodata = 1;
1162 }
1163 }
1164 }
1165
1166 else {
1167
1168 if (arg->
nodata[0][0][0]) {
1169 id = 1;
1174 else
1175 *nodata = 1;
1176 }
1177
1178 else {
1179 id = 0;
1184 else {
1185
1186 id = 1;
1191 else
1192 *nodata = 1;
1193 }
1194 }
1195 }
1196
1197
1198 if (plan != NULL) {
1199 Datum values[12];
1200 char nulls[12];
1201 int err = 0;
1202
1203 TupleDesc tupdesc;
1204 SPITupleTable *tuptable = NULL;
1205 HeapTuple tuple;
1206 Datum datum;
1207 bool isnull =
FALSE;
1208
1210
1211
1212 memset(values, (Datum) NULL,
sizeof(Datum) * callback->
kw.
count);
1213 memset(nulls,
FALSE,
sizeof(
char) * callback->
kw.
count);
1214
1216 int idx = 0;
1217
1218 for (i = 0; i < callback->
kw.
count; i++) {
1220 if (idx < 1) continue;
1221 idx--;
1222
1223 switch (i) {
1224
1225 case 0:
1226 values[idx] = Int32GetDatum(arg->
src_pixel[0][0] + 1);
1227 break;
1228
1229 case 1:
1230 values[idx] = Int32GetDatum(arg->
src_pixel[0][1] + 1);
1231 break;
1232
1233 case 2:
1234
1235 case 3:
1236 if (!arg->
nodata[0][0][0])
1237 values[idx] = Float8GetDatum(arg->
values[0][0][0]);
1238 else
1240 break;
1241
1242
1243 case 4:
1244 values[idx] = Int32GetDatum(arg->
src_pixel[0][0] + 1);
1245 break;
1246
1247 case 5:
1248 values[idx] = Int32GetDatum(arg->
src_pixel[0][1] + 1);
1249 break;
1250
1251 case 6:
1252
1253 case 7:
1254 if (!arg->
nodata[0][0][0])
1255 values[idx] = Float8GetDatum(arg->
values[0][0][0]);
1256 else
1258 break;
1259
1260
1261 case 8:
1262 values[idx] = Int32GetDatum(arg->
src_pixel[1][0] + 1);
1263 break;
1264
1265 case 9:
1266 values[idx] = Int32GetDatum(arg->
src_pixel[1][1] + 1);
1267 break;
1268
1269 case 10:
1270
1271 case 11:
1272 if (!arg->
nodata[1][0][0])
1273 values[idx] = Float8GetDatum(arg->
values[1][0][0]);
1274 else
1276 break;
1277 }
1278
1279 }
1280 }
1281
1282
1283 err = SPI_execute_plan(plan, values, nulls,
TRUE, 1);
1284 if (err != SPI_OK_SELECT || SPI_tuptable == NULL || SPI_processed != 1) {
1285 elog(ERROR, "rtpg_nmapalgebraexpr_callback: Unexpected error when running prepared statement %d", id);
1286 return 0;
1287 }
1288
1289
1290 tupdesc = SPI_tuptable->tupdesc;
1291 tuptable = SPI_tuptable;
1292 tuple = tuptable->vals[0];
1293
1294 datum = SPI_getbinval(tuple, tupdesc, 1, &isnull);
1295 if (SPI_result == SPI_ERROR_NOATTRIBUTE) {
1296 if (SPI_tuptable) SPI_freetuptable(tuptable);
1297 elog(ERROR, "rtpg_nmapalgebraexpr_callback: Could not get result of prepared statement %d", id);
1298 return 0;
1299 }
1300
1301 if (!isnull) {
1302 *
value = DatumGetFloat8(datum);
1304 }
1305 else {
1306
1310 else
1311 *nodata = 1;
1312 }
1313
1314 else {
1317 else
1318 *nodata = 1;
1319 }
1320 }
1321
1322 if (SPI_tuptable) SPI_freetuptable(tuptable);
1323 }
1324
1326 return 1;
1327}
#define POSTGIS_RT_DEBUG(level, msg)
#define POSTGIS_RT_DEBUGF(level, msg,...)
struct rtpg_nmapalgebraexpr_callback_arg::@18 expr[3]
struct rtpg_nmapalgebraexpr_callback_arg::@20 kw
struct rtpg_nmapalgebraexpr_callback_arg::@19 nodatanodata