View with parameters ?

From: "Peter Alberer" <h9351252(at)obelix(dot)wu-wien(dot)ac(dot)at>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: View with parameters ?
Date: 2001-07-24 13:55:38
Message-ID: KOECKFCFMGACJKCHOBBFEEBCCAAA.h9351252@obelix.wu-wien.ac.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andre Schnabel 2001-07-24 17:53:36 Re: View with parameters ?
Previous Message Henry House 2001-07-19 01:38:22 Re: Is there unsigned datatype in PostgreSQL?