Postgres Pro
Downloads
Home   >   mailing lists

Question on returning Rows in a stored proc - Mailing list pgsql-novice

From Richard Sickler
Subject Question on returning Rows in a stored proc
Date
Msg-id f2b12cc10903241008o3f810d7eqdeab67893f960bad@mail.gmail.com
Whole thread Raw
Responses Re: Question on returning Rows in a stored proc  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: Question on returning Rows in a stored proc  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-novice
Tree view
Hi,

I'm new to pl/pgsql and while exploring the world of writing stored procs, I came up with a question that I hope some kind person can help me with, namely, how does one return a bunch of rows?
From the examples that I've found on the web, I can return and integer, a real, etc.  But if I wanted to return the results of something like a query, (e.g. SELECT * FROM foo), how would I do that?

Rich

pgsql-novice by date:

Previous
From: Andreas
Date:
Subject: How modify a sql-function without breaking views ?
Next
From: Andreas Kretschmer
Date:
Subject: Re: Question on returning Rows in a stored proc