Sender: teo@flex.flex.ro
Message-ID: <3891C356.3DB84582@flex.ro>
Date: Fri, 28 Jan 2000 18:27:02 +0200
From: Constantin Teodorescu <teo@flex.ro>
MIME-Version: 1.0
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: How to get the X or Y coordinate from a point field?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

It may be a stupid question but I didn't find the answer in the docs!

I want to hold in a table column a complex reference type to some data
as a pair (table id, record id) and I had in mind to use a "point" data
type.

Now, I want to wind the right record in the right table in a SQL
sentence but I have to extract the X coordinate from the point (and use
it then to build the table name) and the Y coordinate to point to the
record ID. But I didn't find some functions for this. Any clue?

Or, is there is any other sollution for my problem?

Thanks in advance,


Constantin Teodorescu
FLEX Consulting Braila, ROMANIA