agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: DONKERS H.C. 436/3H01/2-5 <Donkers@fel.tno.nl>
To: postgres@postgres.Berkeley.EDU
Subject: newbie question about types
Date: 13 Jun 95 10:29:27 EDT
Message-ID: <9506130832.AA29069@fel.tno.nl> (raw)

Hello,

I'm currnetle doing a graduate project at TNO-FEL in the Netherlands.
Thereby I'm using Postgres, whith which I haven't got any thorough 
experience.

My data in the database consists of 2D polygons. These polygons are
of a self-made type POLYGON2 (I got this from somebody who worked
with Postgres, but he's not working here anymore.).
These polygons all lie in the same 2 dimensional plane.

The program I'm making (for visualisation of the data) is supposed
to handle very large databases (probably up to some Gigabytes), so
it's not very wise to import my data all at once. 

What I want to do is as follows:
The user walks around in the database and with him moves a 'window' 
on the database. So I want to query the database as follows:

RETRIEVE (plg.all)
WHERE overlap(plg.poly, window)

Here window is a constant of type box, polygon or something else if 
that achieves better performance.

My questions now are about the function overlap.
Can you write this youselve?
Is it hard?
Does it take a lot of time?
Could I better convert my data to the type polygon, which comes 
standard with postgres?
Does such a function exist allready for that type?

If you have any questions please ask them, because I really need 
these answers quick.
Any help would be greatly appreciated.

Greetings,
Kurt.

***
In /dev/null no one can hear you scream
***

H.C. (Kurt) Donkers
TNO Physics & Electronical Lab.
P.O. Box 96864
2509 JG The Hague
The Netherlands
Tel: +31 70 3264221
Fax: +31 70 3280961
E-mail: donkers@fel.tno.nl

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: Donkers@fel.tno.nl
  Subject: Re: newbie question about types
  In-Reply-To: <9506130832.AA29069@fel.tno.nl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox