Merkel Marcel wrote: >>That's a creative approach... Why doesn't it work? I haven't worked > with >>arrays in postgres yet, so I don't know much about them. >> > It simply gives me NULL as result don't know why. In the postgre manual > I found that snippet (chapter 9.9) :
(On a sidenote, this causes no end of confusion in the world: the short name for PostgreSQL is Postgres, not Postgre!) > I tried some combinations and the following works: > > SELECT (box[0])[0], (box[0])[1], (box[1])[0], (box[1])[1] FROM ... Looks like C-style A[i][j] indexing doesn't work for multidimensional arrays. Maybe they normally use Fortran-style A[j,i] or Pascal-style A[i,j] indexing... Jeroen _______________________________________________ Libpqxx-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/libpqxx-general
