Application: gvSIG desktop

    "description": ["Returns the location of a search string in a string. If a start position is used, the characters before it are ignored.",

      " If position is negative, the rightmost location is returned. 0 is returned if the search string is not found.",

      "Example: LOCATE('.', NAME)"],

}

        "geometryB - A geometry"

    ],

    "description": "Returns TRUE if no point in Geometry B is outside Geometry A",

}

        "geometryB - Geometry againt you have to calculate"

    ],

    "description": ["Returns TRUE if geometry A is completely inside geometry B."],

}

        "point - Geometry point from which you have to calculate "

    ],

    "description": "Return the X coordinate of the point.",

}

    "alias": [

      "CHR"

    ],

}

        "number_of_chars - The number of characters to extract"

    ],

    "description": "Returns the rightmost number of characters. Example: RIGHT(NAME, 3)",

}

        "geometry - Geometry from which you have to calculate your WKT"

    ],

    "description": "Returns the Well-Known Text representation of the geometry.\nWKT format does not maintain precision so to prevent floating truncation, use ST_AsBinary or ST_AsEWKB format for transport.",

}

        "geometryB - Geometry againt you have to calculate"

    ],

    "description": ["RReturns TRUE if the only points in common between g1 and g2 lie in the union of the boundaries of g1 and g2."],

}

        "lenght - The number of characters to extract."

    ],

    "description": "Returns a substring of a string starting at a position. If the start index is negative, then the start index is relative to the end of the string. The length is optional. Also supported is: SUBSTRING(string [FROM start] [FOR length]). Example: SUBSTR('[Hello]', 2, 5); SUBSTR('Hello World', -5);",

}

        "number - A numeric value"

    ],

    "description": "Returns the largest integer value that is smaller than or equal to a number.",

}

        "a - an angle, in radians."

    ],

    "description": "Returns the tan value.",

}

            "- If the argument is zero, then the result is a zero with the same sign as the argument.",

            "The computed result must be within 1 ulp of the exact result. Results must be semi-monotonic.",

            "ATAN({{a}})"],

}

        "geometry - Geometry from which you have to calculate "

    ],

    "description": "Returns the float8 minimum bounding box for the supplied geometry, as a geometry. The polygon is defined by the corner points of the bounding box ((MINX, MINY), (MINX, MAXY), (MAXX, MAXY), (MAXX, MINY), (MINX, MINY)). (PostGIS will add a ZMIN/ZMAX coordinate as well).",

}

      "Overlaps, Touches, Within all imply spatial intersection.",

      "If any of the aforementioned returns true, then the geometries also spatially intersect.",

      "Disjoint implies false for spatial intersection."],

}

        "geometry - Geometry from which you have to calculate "

    ],

    "description": "Returns the number of Geometries. If geometry is a GEOMETRYCOLLECTION (or MULTI*) return the number of geometries, for single geometries will return 1, otherwise return NULL.",

}

        "number - A number to calculate the square root of. Must be greater than 0"

    ],

    "description": "Return the square root of a number.",

}

        "geometry - Geometry from which you have to calculate "

    ],

    "description": "Returns 0 for POINT, 1 for LINESTRING, 2 for POLYGON, and the largest dimension of the components of a GEOMETRYCOLLECTION. If the dimension is unknown (empty GEOMETRYCOLLECTION) 0 is returned.",

}

        "string - The string to remove trailing spaces from"

    ],

    "description": "Removes all trailing spaces from a string. Example: RTRIM(NAME)",

}

        "geometryB - A geometry"

    ],

    "description": "Returns a geometry that represents that part of geometry A that does not intersect with geometry B. One can think of this as GeometryA - ST_Intersection(A,B). If A is completely contained in B then an empty geometry collection is returned.",

}

        "geometryB - Geometry againt you have to calculate the distance"

    ],

    "description": "For geometry type returns the minimum 2D Cartesian distance between two geometries in projected units (spatial ref units). For geography type defaults to return the minimum geodesic distance between two geographies in meters. If use_spheroid is false, a faster sphere calculation is used instead of a spheroid.",

}

        "The types of expr1 and expr2 are INTEGER or LONG, and the result is of type INTEGER or LONG.",

        "If the types of expr1 or expr2 are not INTEGER or LONG a error is raised."

      ],

}

      "Example:\n",

      "CONCAT(NAME, '!')"

    ],

}

        ""

    ],

    "description": "Returns pi value.",

}

      "ST_Intersection in conjunction with ST_Intersects is very useful for clipping geometries such as in",

      "bounding box, buffer, region queries where you only want to return that portion of a geometry",

      " that sits in a country or region of interest."],

}

            "- If the argument value is less than zero but greater than -1.0, then the result is negative zero.",

            "Note that the value of Math.ceil(x) is exactly the value of -Math.floor(-x)."

          ],

}

        "geometry - Geometry from which you have to calculate "

    ],

    "description": "Returns the first point.",

}

        "geometry - Geometry from which you have to calculate your centroid"

    ],

    "description": "Computes the geometric center of a geometry, or equivalently, the center of mass of the geometry as a POINT",

}

        "point - Geometry point from which you have to calculate "

    ],

    "description": "Return the Y coordinate of the point.",

}

        "The second parameter is zero-indexed; the least significant ",

        "it has position 0"

      ],

}

        "number - A number. Must be greater than 0"

    ],

    "description": "Returns the natural logarithm of a specified number, or the logarithm of the number to the specified base.",

}

        "srid - Optional. Spatial Reference System ID. If SRID is not specified, it defaults to 0 (Unknown)."

    ],

    "description": "Takes a well-known binary representation of a geometry and a Spatial Reference System ID (SRID) and creates an instance of the appropriate geometry type. This function plays the role of the Geometry Factory in SQL",

}

        "WKTtext - WKT text representation of the geometry"

    ],

    "description": "Constructs a ST_Geometry object from the OGC Well-Known text representation.",

}

      "Example:\n",

      "ASCII('Hi')"

    ],

}

        "a - an angle, in radians."

    ],

    "description": "Returns the sin value.",

}

        "geometryB - Geometry againt you have to calculate the disjoint"

    ],

    "description": "Overlaps, Touches, Within all imply geometries are not spatially disjoint. If any of the aforementioned returns true, then the geometries are not spatially disjoint. Disjoint implies false for spatial intersection.",

}

    "description": ["The ASIN() function returns the arc sine of a number.",

      "The specified number must be between -1 to 1, otherwise this function returns NULL. "

      ],

}

        "number - The number of spaces to be returned"

    ],

    "description": "Returns a string consisting of a number of spaces. Example: SPACE(80)",

}

        "geometry - A geometry"

    ],

    "description": "The convex hull of a geometry represents the minimum convex geometry that encloses all geometries within the set.\nOne can think of the convex hull as the geometry you get by wrapping an elastic band around a set of geometries. This is different from a concave hull which is analogous to shrink-wrapping your geometries.",

}

        "geometryB - Geometry againt you have to calculate"

    ],

    "description": ["Return an union of both geometries."],

}

      "Example:",

      "INSTR(EMAIL,'@')"

    ],

}

        "string - The original string that will be searched"

    ],

    "description": "Returns the location of a search string in a string. See also LOCATE. Example: POSITION('.', NAME)",

}

        "number - numeric value"

    ],

    "description": "Returns the absolute value of a number.",

}

        "string - The string to remove spaces or characters from"

    ],

    "description": "Removes all leading spaces, trailing spaces, or spaces at both ends, from a string. Other characters can be removed as well. Example: TRIM(BOTH '_' FROM NAME)",

}

        "geometry - Geometry from which you have to calculate your area"

    ],

    "description": "Returns the area of the geometry if it is a Polygon or MultiPolygon. Return the area measurement of an ST_Surface or ST_MultiSurface value. For geometry, a 2D Cartesian area is determined with units specified by the SRID.",

}

        "a - value in radians"

    ],

    "description": "Converts a value in radians to degrees.",

}

        "point - Geometry point from which you have to calculate "

    ],

    "description": "Return the Z coordinate of the point.",

}

      "If the length is shorter than the string, it will be truncated at the end.",

      "If the padding string is not set, spaces will be used.",

      "Example: LPAD(AMOUNT, 10, '*') "],

}

        "number - A number greater than 0"

    ],

    "description": "Returns the natural logarithm of a number to base-10.",

}

      "- If the argument is NaN or an infinity, then the result is NaN.",

      "The computed result must be within 1 ulp of the exact result. Results must be semi-monotonic."

      ],

}

        "geometryB - A geometry"

    ],

    "description": "Geometry A contains Geometry B if and only if no points of B lie in the exterior of A, and at least one point of the interior of B lies in the interior of A. An important subtlety of this definition is that A does not contain its boundary, but A does contain itself.\nReturns TRUE if geometry B is completely inside geometry A. For this function to make sense, the source geometries must both be of the same coordinate projection, having the same SRID. ST_Contains is the inverse of ST_Within. So ST_Contains(A,B) implies ST_Within(B,A) except in the case of invalid geometries where the result is always false regardless or not defined.",

}

    ],

    "description": ["The ACOS() function returns the arc cosine of a number.",

      "The specified number must be between -1 to 1, otherwise this function returns NULL."],

}

        "value whose arc tangent is to be returned"

    ],

    "description": "Right pad the string to the specified length. If the length is shorter than the string, it will be truncated. If the padding string is not set, spaces will be used. Example: RPAD(TEXT, 10, '-')",

}

        "<img src=\"@@@.d/st_crosses04.png\">\n",

        "LINESTRING/LINESTRING\n"

    ],

}

        "number - The number to be rounded"

    ],

    "description": "Rounds a number to a specified number of decimal places.",

}

        "string - The string to remove leading spaces from"

    ],

    "description": "Removes all leading spaces from a string. Example: LTRIM(NAME) ",

}

        "string - The string to convert"

    ],

    "description": "Converts a string to lowercase. Example:LOWER(NAME)",

}

        "string - The string to convert"

    ],

    "description": "Converts a string to uppercase. Example: UPPER(NAME)",

}

        "exp - exponent value"

    ],

    "description": "Returns the exponent value to a number",

}

        "geometry - Geometry from which you have to calculate "

    ],

    "description": "Returns the spatial reference identifier for the ST_Geometry as defined in spatial_ref_sys table.",

}

      "The types of expr1 and expr2 are INTEGER or LONG, and the result is of type INTEGER or LONG.",

      "If the types of expr1 or expr2 are not INTEGER or LONG a error is raised."

    ],

}

        "new_string - The new replacement string"

    ],

    "description": "Replaces all occurrences of a search string in a text with another string. If no replacement is specified, the search string is removed from the original string. If any parameter is null, the result is null. Example: REPLACE(NAME, ' ')",

}

        "n - value to count"

    ],

    "description": "Return the Nth point in a single linestring or circular linestring in the geometry. Negative values are counted backwards from the end of the LineString, so that -1 is the last point. Returns NULL if there is no linestring in the geometry.",

}

      "The types of expr1 and expr2 are INTEGER or LONG, and the result is of type INTEGER or LONG.",

      "If the types of expr1 or expr2 are not INTEGER or LONG a error is raised.",

    ],

}

        "radius - radius of the buffer"

    ],

    "description": "Returns a geometry that represents all points whose distance from this Geometry is less than or equal to distance.",

}

        "n - integer value"

    ],

    "description": "Return the 1-based Nth geometry if the geometry is a GEOMETRYCOLLECTION, (MULTI)POINT, (MULTI)LINESTRING, MULTICURVE or (MULTI)POLYGON, POLYHEDRALSURFACE Otherwise, return NULL",

}

        ""

    ],

    "description": "Returns the zero value.",

}

        "number - The number of times to repeat the string"

    ],

    "description": "Returns a string repeated some number of times. Example: REPEAT(NAME || ' ', 10)",

}

        "number - A number in degrees"

    ],

    "description": "Converts a degree value into radians.",

}

      "This method returns a long. For BLOB, CLOB, BYTES and JAVA_OBJECT, the precision is used.",

    "Example: LENGTH(NAME)"

  ],

}

          "data - A string value with the data to be converted",

          "format - A string value indicating the format of the input data. The default value is 'hex'."

    ],    

}

        "* If no seed is specified, it returns a completely random number"

    ],

    "description": "Returns a random number between 0 (inclusive) and 1 (exclusive).",

}

      "- If the argument is zero, then the result is 1.0.",

      "The computed result must be within 2.5 ulps of the exact result."

      ] ,

}

        "geometry - Geometry from which you have to calculate "

    ],

    "description": "Returns the last point of a LINESTRING geometry as a POINT or NULL if the input parameter is not a LINESTRING.",

}

        "geometryB - A geometry"

    ],

    "description": "Returns TRUE if no point in Geometry A is outside Geometry B",

}

        "len - Number of characters to extract. If the number exceeds the number of characters in string, it returns string"

    ],

    "description": "Returns the leftmost number of characters. Example: LEFT(NAME, 3)",

}

        "a - an angle, in radians."

    ],

    "description": "Return the tangent of a number.",

}

        "geometry - Geometry from which you have to calculate "

    ],

    "description": "Returns true if this Geometry has no anomalous geometric points, such as self intersection or self tangency. ",

}

    ],

    "description": ["returns e raised to the power of the specified number.",

    "The constant e (2.718281...), is the base of natural logarithms."],

}

      "- If the argument is zero, then the result is 1.0.",

      "The computed result must be within 2.5 ulps of the exact result."

      ] ,

}

    "If number > 0, it returns 1",

    "If number = 0, it returns 0",

    "If number < 0, it returns -1"],

}

        "geometryB - Geometry againt you have to calculate the intersection"

    ],

    "description": ["Returns TRUE if the Geometries 'spatially overlap'. By that we mean they intersect, but one does not completely contain another."],

}

        "geometry - Geometry from which you have to calculate "

    ],

    "description": "Test if an ST_Geometry value is well formed.",

}

        "a - an angle, in radians."

    ],

    "description": "Return the hyperbolic sine of a number.",

}

        "geometry - Geometry from which you have to calculate "

    ],

    "description": "Return the number of points.",

}

        "geometry - Geometry from which you have to calculate "

    ],

    "description": "Returns the 2D perimeter of the geometry/geography if it is a ST_Surface, ST_MultiSurface (Polygon, MultiPolygon). 0 is returned for non-areal geometries. For linear geometries use ST_Length. For geometry types, units for perimeter measures are specified by the spatial reference system of the geometry.",

}