On 19 Jul 2012, at 24:20, Bob Pawley wrote: > When I substitute new.fluid_id for the actual fluid)id the expression returns the right value. > > Following is the table - > > CREATE TABLE p_id.fluids > ( > p_id_id integer, > fluid_id serial, I think people meant the one on which the trigger fires ;) This one can't (shouldn't) be it, or you would introduce in an infinite loop by calling update on the same table. > On 07/18/2012 12:28 PM, Bob Pawley wrote: >> It's an insert after trigger function. >> >> The table has a column named fluid_id. > > Can we see the table schema. What I am looking for is quoted column name > that would preserve case. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
