Re: strange behavior of plpgsql function

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Justin <justin(at)emproshunts(dot)com>
Cc: c k <shreeseva(dot)learning(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: strange behavior of plpgsql function
Date: 2009-04-04 21:22:30
Message-ID: b42b73150904041422h787ca55ao89e9804768fa11de@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Apr 4, 2009 at 10:07 AM, Justin <justin(at)emproshunts(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris spotts 2009-04-04 21:29:55 Re: uuid-ossp
Previous Message Devrim GÜNDÜZ 2009-04-04 20:35:17 Re: uuid-ossp