Re: Select Into help - Mailing list pgsql-novice

From John DeSoi
Subject Re: Select Into help
Date
Msg-id 153AD5B0-AED0-4C9D-990E-F067A229A7D5@pgedit.com
Whole thread Raw
In response to Select Into help  (brian stapel <brians_224@hotmail.com>)
List pgsql-novice
On Jan 18, 2007, at 11:08 AM, brian stapel wrote:

> Below is my current version of the function.  It compiles and
> executes.  How ever, it returns only one record - the last select
> into statement


This is because you only call return next one time. You need to call
it multiple times in a loop if you expect to return a set of records.
This article is somewhat old, but has some detailed examples:

http://www.postgresql.org/docs/techdocs.17






John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


pgsql-novice by date:

Previous
From: Neal Clark
Date:
Subject: Re: Send all postgres messages to a specific folder
Next
From: johnf
Date:
Subject: simple way to filter the available schemas