[postgis-users] Collect problem - 2

[Daniel]

In addition to my previous post: error remain when all self-intersecting 
polygons are removed. Why the tests in the query  fails to filter only 
valid geometries ? (with the right dimension:2) ???

Hello,

I've used to proceed queries like:
SELECT collect(lga_geom) as buffer FROM lg_annee
WHERE lga_annee='2005' and lga_nat_cdn=2 and lga_var>-1 GROUP BY lga_annee;

With last versions of Postgis, such queries failed, even if I add tests 
like:

SELECT collect(lga_geom) as buffer FROM lg_annee
WHERE lga_annee='2005' and lga_nat_cdn=2 and lga_var>-1 and lga_geom is 
not null
and isvalid(lga_geom) and dimension(lga_geom)=2 GROUP BY lga_annee;

Errors reported are:

NOTICE:  Self-intersection
[....]
NOTICE:  Self-intersection
NOTICE:  Self-intersection

ERROR:  lwcollection_construct: mixed dimension geometries

Table lg_annee contain 2-dimension polygon geometries. The query worked 
fine with older versions.

What can I do ?

Any idea ?

dF



-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: file:///tmp/nsmail-1.asc
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060502/a2949403/attachment.asc>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: daniel.faivre.vcf
Type: text/x-vcard
Size: 323 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060502/a2949403/attachment.vcf>