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.