Re: strange behavior of plpgsql function - Mailing list pgsql-general

From Merlin Moncure
Subject Re: strange behavior of plpgsql function
Date
Msg-id b42b73150904041422h787ca55ao89e9804768fa11de@mail.gmail.com
Whole thread Raw
In response to Re: strange behavior of plpgsql function  (Justin <justin@emproshunts.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: uuid-ossp
Next
From: Chris spotts
Date:
Subject: Re: uuid-ossp