Re: Dynamic SQL in Function

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: rwade(at)uci(dot)edu
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dynamic SQL in Function
Date: 2009-04-22 18:55:20
Message-ID: b42b73150904221155v30d5da53obb29f7bace53755e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

n Wed, Apr 22, 2009 at 2:54 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> On Wed, Apr 22, 2009 at 12:29 PM,  <rwade(at)uci(dot)edu> wrote:
>> If I have built a dynamic sql statement in a function, how do i return it
>> as a ref cursor?
>
> CREATE FUNCTION reffunc(_ref) RETURNS refcursor AS

oops

CREATE FUNCTION reffunc(_ref refcursor) RETURNS refcursor AS

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2009-04-22 19:02:33 Re: Error installing Postgres
Previous Message Thomas Kellerer 2009-04-22 18:54:48 Re: Error installing Postgres