It's an insert after trigger function.
The table has a column named fluid_id.
Bob
-----Original Message-----
From: Alan Hodgson
Sent: Wednesday, July 18, 2012 11:15 AM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: Trouble with NEW
On Wednesday, July 18, 2012 11:07:34 AM 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” “.
Is that run within an insert or update trigger function? Does the table it's
on have a field named fluid_id?
Bob
--
When the Athenians finally wanted not to give to society but for society to
give to them, when the freedom they wished for most was freedom from
responsibility, then Athens ceased to be free and was never free again.” --
Edward Gibbon
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
