From: Constantin Teodorescu <teo@flex.ro>
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: How to get the X or Y coordinate from a point field?
Date: Fri, 28 Jan 2000 18:27:02 +0200
Message-ID: <3891C356.3DB84582@flex.ro> (raw)
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
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: pgsql-interfaces@postgresql.org
Cc: teo@flex.ro
Subject: Re: How to get the X or Y coordinate from a point field?
In-Reply-To: <3891C356.3DB84582@flex.ro>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox