[postgis-devel] Building multidimensional arrays from tuple sets

strk strk at keybit.net
Tue Dec 28 01:56:26 PST 2010


Does anyone here have a neat trick to build something like:

  '{{1,2},{10,20}}'::int[][]

>From this input:

   a  | b
   ---+----
   1  | 2
   10 | 20
   (2 rows)

Such bidimensional arrays are used for TopoElementArray in
postgis topology. I can't find an easy way to deal with them
so I'm wondering if I should provide some as part of topology.sql

Power user tips, otherwise ?

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html



More information about the postgis-devel mailing list