Changes

Patent Assignment Data Restructure (view source)

553 bytes added , 16:18, 10 April 2017

ELSE NULL END AS result;

$$ LANGUAGE SQL;

With these functions, we can generate ptoassigneend_us_extract, which is the final output of all the extraction steps, with the following code:

CREATE TABLE ptoassigneend_us_ AS

SELECT *, ExtractPostcode(city) postcode_city,

ExtractPostcode(addrline1) postcode_addr1,

ExtractPostcode(addrline2) postcode_addr2,

ExtractState(city) state_city,

ExtractState(addrline1) state_addr1,

ExtractState(addrline2) state_addr2

ExtractCity(city) city_city,

ExtractCity(addrline1) city_addr1,

ExtractCity(addrline2) city_addr2

FROM ptoassigneend_missus;

====Issues====

353

edits