View with parameters ?

Поиск
Список
Период
Сортировка
От Peter Alberer
Тема View with parameters ?
Дата
Msg-id KOECKFCFMGACJKCHOBBFEEBCCAAA.h9351252@obelix.wu-wien.ac.at
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Leandro Fanzone"
Дата:
Сообщение: ANSI SQL
Следующее
От: A_Schnabel@t-online.de (Andre Schnabel)
Дата:
Сообщение: Re: View with parameters ?