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