On 07/18/2012 12:07 PM, Bob Pawley wrote:
> 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
Are you in a trigger?