| From: | Chris Ruprecht <chrup999(at)yahoo(dot)com> |
|---|---|
| To: | "Eric Day" <eday(at)sandibooks(dot)com> |
| Cc: | PostGreSQL Admin Group <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How can I.. |
| Date: | 2001-10-27 20:19:59 |
| Message-ID: | p05101003b800c6cbae3f@[192.168.0.4] |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Eric,
>How do I create a stored procedure which would return a few records with a
>few columns each ?
>
>Regards,
>Eric
Create a temp table, delete all it's records. Then have run your
procedure which will create records in the temp table. You have
access to the records in the temp table from your calling procedure.
Sorry, but there is no data type 'record' which can be used to return
a records (row, tuple, etc.) in PostGreSQL at the moment.
Best regards,
Chris
--
--
Chris Ruprecht
Network grunt and bit pusher extraordinaíre
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2001-10-28 08:22:24 | UNICODE |
| Previous Message | Chris Ruprecht | 2001-10-27 20:16:35 | Re: [Solution] PG 7.1.3 & MacOS X (10.1) |