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

Поиск
Список
Период
Сортировка
От Constantin Teodorescu
Тема How to get the X or Y coordinate from a point field?
Дата
Msg-id 3891C356.3DB84582@flex.ro
обсуждение исходный текст
Список 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


В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Christoph Fister
Дата:
Сообщение: JDBC-IE5-no suitable driver
Следующее
От: "Uillian Fernandes"
Дата:
Сообщение: