On Thu, Mar 3, 2011 at 6:41 AM, Nick Raj <nickrajj...@gmail.com> wrote:
> Which type of data type will be used in above function (in place of ?????) > that can collect more than one row(20,000) ? > Maybe the id that those 20M records have in common? hth, WBL On Thu, Mar 3, 2011 at 6:41 AM, Nick Raj <nickrajj...@gmail.com> wrote: > Hi, > I am writing some function in postgres pl/sql. > > My function is of type St_ABC((select obj_geom from XYZ),(select > boundary_geom from boundary)) > I have table XYZ with 20,000 tuples and in boundary, i have only one > geometry. > > In postgres, ST_intersects(obj_geom, boundary_geom) checks each obj_geom > with boundary_geom and returns true/false. It returns true/false 20,000 > times > I want to write function that return only one true/false according to my > calculation. > > So, create or replace function ST_ABC(?????, geometry) returns boolean > > Which type of data type will be used in above function (in place of ?????) > that can collect more than one row(20,000) ? > > Thanks > Raj > -- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw