How to get the X or Y coordinate from a point field?

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: How to get the X or Y coordinate from a point field?
Date: 2000-01-28 16:27:02
Message-ID: 3891C356.3DB84582@flex.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Uillian Fernandes 2000-01-28 18:00:12
Previous Message Christoph Fister 2000-01-28 16:08:49 JDBC-IE5-no suitable driver