Re: View with parameters ?
От | A_Schnabel@t-online.de (Andre Schnabel) |
---|---|
Тема | Re: View with parameters ? |
Дата | |
Msg-id | 000b01c11469$90d0a900$0201a8c0@aschnabel.homeip.net обсуждение исходный текст |
Ответ на | View with parameters ? ("Peter Alberer" <h9351252@obelix.wu-wien.ac.at>) |
Список | pgsql-novice |
Hi, views don't take parameters. But if you include the custumerid in your view, you can simply select a single row. ----- Original Message ----- From: Peter Alberer To: pgsql-novice@postgresql.org Sent: Tuesday, July 24, 2001 3:55 PM Subject: [NOVICE] View with parameters ? Hi there, i wanted to know if there is a possibility to construct something like a view or procedure with parameters that returns rows. for example i would like to create a procedure that returns details about a customer. i imagine something like a procedure or view called user_details that takes a user_id as argument and returns the details for that specific customer as one row. the examples of functions or views i saw for postgres had no parameters (the views) or did return single values (the functions) am i missing something ? tia, peter@alberer.com ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
В списке pgsql-novice по дате отправления: