[GENERAL] Trouble with NEW

[Bob Pawley]

Hi

I would appreciate some fresh eyes on this expression -

update p_id.fluids
    set fluid_short =
    (select shape.text
    from  shape, num_search
    where (select st_within(shape.wkb_geometry, 
st_geometryn(num_search.the_geom4, 1)) = 'true')    
    and text !~ '[0-9]')
    where p_id.fluids.fluid_id = NEW.fluid_id; 

I receive an error ”record “new” has no field “fluid_id” “.

Bob