data type

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

Responses

Browse pgsql-general by date

  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