given a table with a point in it, how do I create a table with separate x, y values?

Jerry Asher

I have a table sort of like:

create table firehydrants (
center point,
hydrant integer primary key,
);

How do I create firehyrants2 from firehydrants where the points are
broken out into their x and y values?

create table firehydrants2 (
x float,
y float,
hydrant integer primary key,
);

Thank you,

Jerry Asher

Jul 19 '05 #1