From: | Nick Raj <nickrajjain(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | data type |
Date: | 2011-03-03 05:41:41 |
Message-ID: | AANLkTi=vLTPREUQ5ZqZkMEBSjuGLp7P12NL4ZA=hK+KT@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alpha Beta | 2011-03-03 11:59:44 | Integrated Trigers |
Previous Message | Craig Ringer | 2011-03-03 01:45:06 | Re: ERROR: invalid byte sequence for encoding "UTF8": 0xc35c |