<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
The <br>
<br>
<i>SELECT rid, ST_Reclass(ST_Band(rast, 1), 1, '[1-10000]:1',
'16BSI', 0) </i><i><br>
</i><i>
FROM rastertmp.prova</i><i><br>
<br>
</i>in<br>
<br>
WITH <br>
positiu AS (<br>
SELECT rid, ST_Reclass(ST_Band(rast, 1), 1, '[1-10000]:1',
'16BSI', 0) <br>
FROM rastertmp.prova<br>
)....<br>
<br>
does not contain a column "rast". The original table rastertmp.prova
does contain the aforementioned column.<br>
<br>
positiu is aliased to t2 in the second clause in the with statement,
hence the error message "t2.rast..."<br>
<br>
You might rewrite the select as this <br>
<br>
<i>SELECT rid, ST_Reclass(ST_Band(rast, 1), 1, '[1-10000]:1',
'16BSI', 0) <b>as rast</b> </i><i><br>
</i><i>
FROM rastertmp.prova</i><br>
<br>
if it's the reclassified rast you're interested in<br>
<br>
Regards <br>
Bo Victor Thomsen<br>
AestasGIS <br>
Denmark<br>
<br>
<div class="moz-cite-prefix">On 31-07-2015 12:43, juli g. pausas
wrote:<br>
</div>
<blockquote
cite="mid:CAD6WO6Q3Cv5=QOnck2TL2aiHYEkc2aa-awVT9KOCeYKk_VgMBg@mail.gmail.com"
type="cite">WITH <br>
positiu AS (<br>
SELECT rid, ST_Reclass(ST_Band(rast, 1), 1, '[1-10000]:1',
'16BSI', 0) <br>
FROM rastertmp.prova<br>
),</blockquote>
<br>
</body>
</html>