Changes between Version 3 and Version 4 of UsersWikiCheckInvalidGeometriesFromGeometryColumns


Ignore:
Timestamp:
May 8, 2011, 9:32:19 AM (13 years ago)
Author:
aperi2007
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • UsersWikiCheckInvalidGeometriesFromGeometryColumns

    v3 v4  
    1818    sql := 'CREATE TABLE ' || quote_ident(tabris) || ' (id serial, query TEXT, invalidity INTEGER);';
    1919    execute(sql);
    20     sql := 'select ''select count(*) from '' || quote_ident(f_table_schema) || ''.'' || quote_ident(f_table_name) || '' where ST_IsValid('' || f_geometry_column || '')=false;'' as query from public.geometry_columns order by f_table_schema,f_table_name LIMIT 3';
     20    sql := 'select ''select count(*) from '' || quote_ident(f_table_schema) || ''.'' || quote_ident(f_table_name) || '' where ST_IsValid('' || f_geometry_column || '')=false;'' as query from public.geometry_columns order by f_table_schema,f_table_name';
    2121
    2222    FOR _rec1 IN execute (sql)