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