[postgis-users] Geometry vs Linestring

[Pier Lorenzo Marasco]

Hi all,

I'm trying to make something very easy but I've a problem with results.
I've two tables and I need to make lines from the joins of these two. I've
try with this :

CREATE TABLE "l_506" AS
SELECT elements.oid, ST_MakeLine(seeds.geom) AS geom
FROM elements
    JOIN seeds ON (elements.oid=seeds.oid)
WHERE elements.code='0506'
GROUP BY elements.oid;

All the elements in seeds are linestring but what I achieve is a geometry
table. Ok.. I should alter the column type and everything goes as I aspect
but I would like to understand where I'm getting wrong.

L.

-- 
Pier Lorenzo Marasco
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140507/8f94465f/attachment.html>