<html>
<head>
</head>
<body style="margin-top: 4px; line-height: normal; font-variant: normal; margin-bottom: 1px; font-style: normal; margin-right: 4px; margin-left: 4px; font-family: Comic Sans MS; font-size: 12pt; font-weight: normal">
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">try adding another to the "nclheights" line.</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">nclheights AS foobar.</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">Also I don't think that semicolon after the last paren is valid (Before your existing AS . . .)</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">bobb</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<br>
<br>
>>> JamesH <james.holmes@newcastle.ac.uk> wrote:<br> </p>
<table style="margin-top: 0; margin-bottom: 0; margin-right: 0; margin-left: 15px; font-size: 1em" border="0" bgcolor="#f3f3f3">
<tr>
<td>
<div style="padding-left: 7px; border-left: solid 1px #050505">
<p style="margin-top: 0; margin-bottom: 0">
Ok I'm trying OpenJump as I need to get going with this for my dissertation.<br><br>Now I'm connected to the datastore, I am trying to run the following query:<br><br>SELECT ST_AsBinary(rast), slope<br>FROM (SELECT<br> rid, rast,<br>ST_Slope(ST_MapAlgebraExpr(ST_AddBand(ST_MakeEmptyRaster(10, 10, 0, 0, 0.1,<br>0.1, 0, 0, 4269), '8BUI'::text, 1, 0), '32BUI', '([rast.x] - 1) *<br>10 + [rast.y]'), 1, '8BUI'::text) slope<br>FROM<br> nclheights<br> ); AS foo<br><br>Which is returning an error of "subquery in FROM must have an alias."<br>Have I used foo incorrectly?<br><br>Regards,<br>James<br><br>--<br>View this message in context: <a href="http://postgis.17.n6.nabble.com/ST-Slope-tp4551303p4679231.html">http://postgis.17.n6.nabble.com/ST-Slope-tp4551303p4679231.html</a><br>Sent from the PostGIS - User mailing list archive at Nabble.com.<br>_______________________________________________<br>postgis-users mailing list<br>postgis-users@postgis.refractions.net<br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</p>
</div>
</td>
</tr>
</table>
</body>
</html>