Re: Doubt on opaque returntype!! - Mailing list pgsql-general

From Oliver Elphick
Subject Re: Doubt on opaque returntype!!
Date
Msg-id 1032352377.26472.98.camel@linda
Whole thread Raw
In response to Doubt on opaque returntype!!  (Thirumoorthy Bhuvneswari <tbhuvneswari@yahoo.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Thirumoorthy Bhuvneswari
Date:
Subject: Doubt on opaque returntype!!
Next
From: "Mihai Gheorghiu"
Date:
Subject: Re: Help!