Changeset 696


Ignore:
Timestamp:
Sep 5, 2009, 2:54:20 PM (10 years ago)
Author:
Dominic Hargreaves
Message:

null reason

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/npemap.org.uk/scripts/report-foreign-deletions

    r695 r696  
    3636
    3737my $sql = <<EOF;
    38 SELECT id,outward||' '||inward AS postcode,coalesce(to_char(easting,'000000'),''),coalesce(to_char(northing,'000000'),''),coalesce(to_char(ie_easting,'000000'),''),coalesce(to_char(ie_northing,'000000'),''),reason from postcodes p inner join bad_postcodes b on (p.id=b.postcode) where source=? and delete_reason=1 and deleted='t' order by id;
     38SELECT id,outward||' '||inward AS postcode,coalesce(to_char(easting,'000000'),''),coalesce(to_char(northing,'000000'),''),coalesce(to_char(ie_easting,'000000'),''),coalesce(to_char(ie_northing,'000000'),''),coalesce(reason,'') from postcodes p inner join bad_postcodes b on (p.id=b.postcode) where source=? and delete_reason=1 and deleted='t' order by id;
    3939EOF
    4040
Note: See TracChangeset for help on using the changeset viewer.