Arnaud, Great idea. Yes I think that is better, less prone to error and probably faster since integer checks are faster than string checks. I'm assuming the cost of accessing the ST_Dimension is not any more (and probably less) than the cost of accessing the geometry type and both are fairly negligable.
Thanks, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 8:39 AM To: [email protected] Subject: Re: [postgis-users] How to trim a GeometryCollection toget aMultiPolygon? Obe Regina - [EMAIL PROTECTED] a écrit : > WHERE ST_GeometryType(foo.the_geom) ILIKE '%polygon%' Would it be enough to check the dimension of the geomtry in that case ? (i.e. ST_Dimension(foo.the_geom) = 2) And, more important, do you think it be faster than checking its type against a string ? Regards -- Arnaud _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
