The Ultimate Guide to High Availability with MariaDB

ST_Collect

You are viewing an old version of this article. View the current version here.
MariaDB starting with 11.7

ST_Collect was added in MariaDB 11.7.

Syntax

ST_Collect(g)

Description

Given multiple geometries, returns the aggregation of the distinct geometry arguments. This function also supports the DISTINCT option. If DISTINCT is used, it returns the aggregation of the distinct geometry arguments.

The resulting value type is chosen using the following policy:

  • If all arguments are Point values, the result is a MultiPoint value.
  • If all arguments are LineString values, the result is a MultiLineString value.
  • If all arguments are Polygon values, the result is a MultiPolygon value.
  • Otherwise, the result is a GeometryCollection value.

If there are multiple geometry arguments and those arguments are in the same spatial reference system (SRS), the return value is in that SRS. If those arguments are not in the same SRS, an ER_GIS_DIFFERENT_SRIDS_AGGREGATION error occurs.

Examples

See Also



    



        
            

            

        

        
        
    
        

            
        

    

        

        
        
Comments

        
    
    

        Comments loading...
    


        

    



                    

                        Content reproduced on this site is the property of its respective owners,
                        and this content is not reviewed in advance by MariaDB. The views, information and opinions
                        expressed by this content do not necessarily represent those of MariaDB or any other party.