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.hol...@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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
