Re: plpgsql functions

From: Christophe <xof(at)thebuild(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: plpgsql functions
Date: 2008-08-15 21:39:26
Message-ID: 5CC073A9-F606-458F-A2EC-78E2E9F016A7@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Aug 15, 2008, at 1:47 PM, Raymond O'Donnell wrote:
> For functions return SETOF any type, you need to use the following
> idiom:

Or, you can use,

RETURN QUERY <your query here>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Harding 2008-08-15 23:35:10 How to tell if a trigger is disabled
Previous Message Roderick A. Anderson 2008-08-15 21:31:44 Re: [Q] DNS(bind) ER model