Обсуждение: 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

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