/database/layers_prod_updates/017_bath_top_gbr_cat_100811.sql

http://alageospatialportal.googlecode.com/ · SQL · 5 lines · 5 code · 0 blank · 0 comment · 0 complexity · f2f6ef8538a4a30f76d760182215a590 MD5 · raw file 

    

  1. \set ON_ERROR_STOP 1
    2. 

  2. begin;
    3. 

  3. update layers
    4. 

  4. set classification1 = 'Marine', classification2 = 'Bathymetry' where id in(924,848);
    5. 

  5. commit;
    6.