353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 15:20, 10 April 2017
, 15:20, 10 April 2017→Extraction
$$ LANGUAGE SQL;
With these functions, we can generate ptoassigneend_us_extract, which is the final output of all the extraction stepsin Section 2.2.1, with the following code:
CREATE TABLE ptoassigneend_us_ AS
SELECT *, ExtractPostcode(city) postcode_city,
