KNN Function

CREATE TABLE building_height AS 
SELECT b.ogc_fid, geom, id, featcode,  
(SELECT h.prop_value FROM terrain h 
  ORDER BY b.geom <-> h.geom LIMIT 1)
FROM building b;