Re: strange behavior of plpgsql function

On Sat, Apr 4, 2009 at 10:07 AM, Justin <justin@emproshunts.com> wrote:
> I think i may be the way the function is being called??
>
> if you are doing Select fnvs.docrelatedassociatedetails()
>
> it will not return any records, it needs to be
>
> Select * From fnvs.docrelatedassociatedetails()

select func();

will return a set of composite type for sql functions, and error for
plpgsql functions < 8.4.  Starting with 8.4, plpgsql functions will
work as sql functions do.

merlin