Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group