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 ?
pgsql-novice by date
|Next:||From: Andre Schnabel||Date: 2001-07-24 17:53:36|
|Subject: Re: View with parameters ?|
|Previous:||From: Henry House||Date: 2001-07-19 01:38:22|
|Subject: Re: Is there unsigned datatype in PostgreSQL?|