On Wed, 2002-09-18 at 12:01, Thirumoorthy Bhuvneswari wrote:
> This trigger is also created. But, when I try to
> insert into the tableA it comes with the error:
>
> 'ERROR during compile of test_trigger near line 8
> ERROR:return type mismatch in function returning table
> row at or near "opaque"
I think your function should return NULL.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Give, and it shall be given unto you; good measure,
pressed down, and shaken together, and running over,
shall men pour into your lap. For by your standard of
measure it will be measured to in return."
Luke 6:38