Changes

Patent Assignment Data Restructure (view source)

1 byte added , 15:18, 10 April 2017

CREATE OR REPLACE FUNCTION ExtractPostcode(adr text) RETURNS text AS $$

BEGIN

RETURN SUBSTRING(adr, '\d{5}[-]\d{4}');

END;

$$ LANGUAGE plpgsql;

353

edits