Re: SELECT composite type

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