View with parameters ? - Mailing list pgsql-novice

From Peter Alberer
Subject View with parameters ?
Date
Msg-id KOECKFCFMGACJKCHOBBFEEBCCAAA.h9351252@obelix.wu-wien.ac.at
Whole thread Raw
List 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@alberer.com


pgsql-novice by date:

Previous
From: "Leandro Fanzone"
Date:
Subject: ANSI SQL
Next
From: A_Schnabel@t-online.de (Andre Schnabel)
Date:
Subject: Re: View with parameters ?