Using a Storedprocedure as a View
От | Alexander Hachmann |
---|---|
Тема | Using a Storedprocedure as a View |
Дата | |
Msg-id | NGEEJJBKDBJKFGILNCLPGEKJCDAA.public@thesofa.de обсуждение исходный текст |
Ответы |
Re: Using a Storedprocedure as a View
Re: Using a Storedprocedure as a View Re: Using a Storedprocedure as a View Re: Using a Storedprocedure as a View |
Список | pgsql-general |
Hello, I know that this was discussed many times, but all the answers did not help me yet. I need to create a Procedure that returns the same data as a view does except, that the the data was filtered by a parameter. I want to execute a procedure with a parameter and get back a 'view'. I only made prcedures giving back simple values. Can they give back data as Views does. I dont want the procedure to create a view on which i have to query again because the query the Procedure does can go over more stages than just this one. The procedure calls another procedure and handles this as a subselect. Can any one help me? Thx, Alexander
В списке pgsql-general по дате отправления: