- Timestamp:
- Sep 5, 2009, 2:54:20 PM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/npemap.org.uk/scripts/report-foreign-deletions
r695 r696 36 36 37 37 my $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'),''), reasonfrom postcodes p inner join bad_postcodes b on (p.id=b.postcode) where source=? and delete_reason=1 and deleted='t' order by id;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'),''),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; 39 39 EOF 40 40
Note: See TracChangeset
for help on using the changeset viewer.