December 11th, 2001, 07:48 PM
Functions And PostgreSQL
I was wondering if It is possible to return a whole recordset from a function. I managed to return one column, but what if I want to select several columns from a table.
This works fine with a view, but I have not found a way to pass parameters into a view...I need a little of both..
Any help anybody?
December 27th, 2001, 11:24 AM
I think functions, by nature, will only allow you to return one value. What are you trying to return that can't be done with a view?
January 8th, 2002, 12:50 PM
Just trying to store the procedures in postgres
I would just like to store my SQL statements in postgres so I can re-use them. Like a stored procedure in MS SQL (don't want to go there..). Call a function in the database and pass my parameters to it. In return I get the recordset.
I pass a userid to a function and have it return all the users data to me in a recordset.
Sorry for not replying sooner...Have not been in here for a while.
March 18th, 2002, 10:58 PM
March 19th, 2002, 04:05 PM
March 20th, 2002, 09:02 AM
Thanks. I will check those things out.