Hi,
I have a table called "windturbines".
I have created a view called "v_sum_yield".
I would now like to either create another view which consists of both tables
joined with the column "bez", or join the view to the original table.
The table comprises of single wind turbines and their yield per year. I need to
sum the yields according to the region. This table then needs to be served as
wfs/wms through geoserver.
my first step was...
CREATE VIEW v_sum_yield AS
select region, sum(yield) AS result
from windturbines
group by region
and then to create another view comprising of an left outer join to the
original
table...
CREATE VIEW v_join AS
SELECT *
FROM windturbines LEFT OUTER JOIN v_sum_yield ON (windturbines.region =
v_sum_yield.region);
the result is..
ERROR: column "region" specified more than onceSQL Status:42701
however if I just run the selection with the "CREATE VIEW v_join AS"...it works
fine.
can anyone tell me why?
thanks,
Rob
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users