Skip site navigation (1) Skip section navigation (2)

Re: Function Help

From: Joel Burton <jburton(at)scw(dot)org>
To: Bob Whitehouse <bwhitehouse(at)geeknest(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Function Help
Date: 2001-05-04 16:17:11
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
On Fri, 4 May 2001, Bob Whitehouse wrote:

> Can anyone show me an example of a function you've written in plpgsql that
> queries the database and fetches the resulting recordset to make it
> available to an application? I've been searching the documentation for an
> example of this and have not found anything yet.

Look in Mello's PGSQL Cookbook at

I've submitted at least one func that does this.

Joel Burton   <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2001-05-04 16:41:32
Subject: Re: UPDATE and INDEX on expensive function with (IsCachable)
Previous:From: Bob WhitehouseDate: 2001-05-04 15:24:38
Subject: Function Help

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group