Changeset 433
- Timestamp:
- Jan 8, 2007, 6:41:45 PM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/npemap.org.uk/perllib/NPEMap/Postcodes.pm
r353 r433 22 22 SUM(CASE WHEN source = 0 THEN 1 ELSE 0 END) AS us, 23 23 COUNT(DISTINCT outward) AS all_out, 24 COUNT(DISTINCT CASE WHEN source = 0 THEN outward ELSE '' END) - 1 AS us_out 24 COUNT(DISTINCT CASE WHEN source = 0 THEN outward ELSE '' END) - 1 AS us_out, 25 COUNT(DISTINCT CASE WHEN char_length(inward) > 0 THEN 26 outward || ' ' || substr(inward,1,1) 27 ELSE '' END) - 1 AS all_out1, 28 COUNT(DISTINCT CASE WHEN char_length(inward) > 0 THEN 29 CASE WHEN source = 0 THEN 30 outward || ' ' || substr(inward,1,1) 31 ELSE '' END 32 ELSE '' END) - 1 AS us_out1 25 33 FROM postcodes WHERE deleted = 'f'; 26 34 HERE
Note: See TracChangeset
for help on using the changeset viewer.