Re: View with parameters ?

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(at)postgresql(dot)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(at)alberer(dot)com

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html