[postgis-users] compilation raster layers with postgis

[DURANTON Lucie - CEREMA/DTerCE/DETC/CTCS]

Hi everybody !

For information, I work on :

postgis 2.1
postgre 9.4
Qgis 2.12.2

I try to compile together several raster layers with postgis. For 
information, layer "a" has priority over layer "b", and all of my 
rasters are single-band.

This is the code I enter :

DROP TABLE IF EXISTS lucie.compil;
CREATE TABLE lucie.compil
AS
SELECT
CASE
WHEN a.valeur>0 THEN a.rast
ELSE b.rast
END as rast
FROM lucie.test as a join lucie.final_raster as b on 
st_intersects(a.rast,b.rast);

But it doesn’t run...I can’t open the result layer on Qgis...Do you know 
why ?

Thank you very much for your help that would be so precious, because I 
have been searching for 5 months !!!

Lucie
-- 
*Lucie DURANTON*
Chargée d'études SIG

DTerCE - DETC - CTCS
Tel : 04 74 27 53 52
http://www.cerema.fr
CEREMA - Direction territoriale Centre-Est : Cité des mobilités - 25, 
avenue François Mitterrand - CS 92 803 - F-69674 BRON Cedex - Tel : +33 
(0)4 72 14 30 30
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160203/85ce3d93/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Signature_DTerCE.jpg
Type: image/jpeg
Size: 32030 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160203/85ce3d93/attachment.jpg>