<div class="gmail_extra">Thanks Pierre! That works like a charm (with some minor changes because of projections and different point values). It is noticeably faster now too.</div><div class="gmail_extra"><br></div><div class="gmail_extra">
Thanks, again. :-)</div><div class="gmail_extra"><br></div><div class="gmail_extra">Cheers,</div><div class="gmail_extra">Tim<br clear="all"><div>Tim-Hinnerk Heuer<br><br>Twitter: @geekdenz<br><div>Blog: <a href="http://www.thheuer.com/" target="_blank">http://www.thheuer.com</a></div>
</div><br>
<br><br><div class="gmail_quote">On 19 December 2012 10:56, Pierre Racine <span dir="ltr"><<a href="mailto:Pierre.Racine@sbf.ulaval.ca" target="_blank">Pierre.Racine@sbf.ulaval.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div id=":1aa">SELECT p, geom, ST_Value(rast,geom) elev<br>
FROM (SELECT p, ST_line_interpolate_point(<br>
                  ST_GeometryFromText('LINESTRING(-69 46.5, -68 46, -67 46.5, -67 45)', 4326),<br>
                                      CAST(p AS numeric)/30) geom<br>
            FROM generate_series(1,30) p<br>
           ) foo,<br>
         srtm_tiled_100x100<br>
WHERE ST_Intersects(rast, geom)</div></blockquote></div><br></div>