Re: data type

On Thu, Mar 3, 2011 at 6:41 AM, Nick Raj <nickrajjain(at)gmail(dot)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 <nickrajjain(at)gmail(dot)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