Trouble with NEW - Mailing list pgsql-general

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