[postgis-users] ST_Slope

[Bob Basques]

try adding another to the "nclheights" line. 

nclheights AS foobar. 

Also I don't think that semicolon after the last paren is valid (Before your existing AS . . .) 

bobb 



>>> JamesH <james.holmes at newcastle.ac.uk> wrote:


Ok I'm trying OpenJump as I need to get going with this for my dissertation.

Now I'm connected to the datastore, I am trying to run the following query:

SELECT ST_AsBinary(rast), slope
FROM (SELECT
        rid, rast,
ST_Slope(ST_MapAlgebraExpr(ST_AddBand(ST_MakeEmptyRaster(10, 10, 0, 0, 0.1,
0.1, 0, 0, 4269), '8BUI'::text, 1, 0), '32BUI', '([rast.x] - 1) *
10 + [rast.y]'), 1, '8BUI'::text) slope
FROM
        nclheights
        ); AS foo

Which is returning an error of "subquery in FROM must have an alias."
Have I used foo incorrectly?

Regards,
James

--
View this message in context: http://postgis.17.n6.nabble.com/ST-Slope-tp4551303p4679231.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120402/8c8b95e4/attachment.html>