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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
