Thread: Query inside a C-Function
Hello!
I have to make a c function for determining if some point its inside a set of elliptical geometries (I'm talking about a shared library, used like a function in the queries ). The geometries are defined in a table, so the function should iterate over a set of them. One option could be pass as a param to the funcition an array of HeapTupleHeader (if its posible), and other could be make a query inside the function for obtaining the geometries.
I can't find the way of doing none of them, someone knows if it's posible? And, of course, information and links are needed too.
Thank in advance.
Enzo Cappa
I have to make a c function for determining if some point its inside a set of elliptical geometries (I'm talking about a shared library, used like a function in the queries ). The geometries are defined in a table, so the function should iterate over a set of them. One option could be pass as a param to the funcition an array of HeapTupleHeader (if its posible), and other could be make a query inside the function for obtaining the geometries.
I can't find the way of doing none of them, someone knows if it's posible? And, of course, information and links are needed too.
Thank in advance.
Enzo Cappa
On 03/19/2010 12:26 PM, Enzo Cappa wrote: > Hello! > > I have to make a c function for determining if some point its inside a > set of elliptical geometries (I'm talking about a shared library, used > like a function in the queries ). The geometries are defined in a table, > so the function should iterate over a set of them. One option could be > pass as a param to the funcition an array of HeapTupleHeader (if its > posible), and other could be make a query inside the function for > obtaining the geometries. > > I can't find the way of doing none of them, someone knows if it's > posible? And, of course, information and links are needed too. See the SPI functions: http://www.postgresql.org/docs/8.4/interactive/spi.html There are examples of use in the contrib/tablefunc code among others. HTH, Joe