On 5 apr 2006, at 17.57, Michael Burke wrote:
So I basically want to call get_xy for every row in
sightings, and use its output for two columns; or perhaps there is
another
way to think of this.
You could try
SELECT foo.x, foo.y, title FROM
(SELECT
get_xy(SetSRID(sightings.location, 26910), 4326) AS foo,
sightings.title
FROM sightings
WHERE sighting_id = 25) bar;
Sincerely,
Niklas Johansson
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
