Function msPostGISBuildSQLWhere

mappostgis.c:1829–1939

** msPostGISBuildSQLWhere() ** ** Returns malloc'ed char* that must be freed by caller. */

** Returns malloc'ed char* that must be freed by caller.
*/
char *msPostGISBuildSQLWhere(layerObj *layer, rectObj *rect, long *uid) {
    char *strRect = 0;
    char *strFilter = 0;
    char *strUid = 0;
    char *strWhere = 0;
    char *strLimit = 0;
    size_t strRectLength = 0;
    size_t strFilterLength = 0;
    size_t strUidLength = 0;
    size_t strLimitLength = 0;
    size_t bufferSize = 0;
    int insert_and = 0;
    msPostGISLayerInfo *layerinfo;

    if (layer->debug) {
        msDebug("msPostGISBuildSQLWhere called.\n");
    }

    assert( layer->layerinfo != NULL);

    layerinfo = (msPostGISLayerInfo *)layer->layerinfo;

    if ( ! layerinfo->fromsource ) {
        msSetError(MS_MISCERR, "Layerinfo->fromsource is not initialized.", "msPostGISBuildSQLWhere()");
        return NULL;
    }

    /* Populate strLimit, if necessary. */
    if( layer->maxfeatures >= 0 ) {
        static char *strLimitTemplate = " limit %d";
        strLimit = msSmallMalloc(strlen(strLimitTemplate) + 12);
        sprintf(strLimit, strLimitTemplate, layer->maxfeatures);
        strLimitLength = strlen(strLimit);
    }
    
    /* Populate strRect, if necessary. */
    if ( rect && layerinfo->geomcolumn ) {
        char *strBox = 0;
        char *strSRID = 0;
        size_t strBoxLength = 0;
        static char *strRectTemplate = "%s && %s";

        /* We see to set the SRID on the box, but to what SRID? */
        strSRID = msPostGISBuildSQLSRID(layer);
        if ( ! strSRID ) {
            return NULL;
        }

        strBox = msPostGISBuildSQLBox(layer, rect, strSRID);
        if ( strBox ) {
            strBoxLength = strlen(strBox);
        }
        else {
            msSetError(MS_MISCERR, "Unable to build box SQL.", "msPostGISBuildSQLWhere()");
            return NULL;
        }

        strRect = (char*)msSmallMalloc(strlen(strRectTemplate) + strBoxLength + strlen(layerinfo->geomcolumn));