views with parameters
От | Thomas Hermann(Software) |
---|---|
Тема | views with parameters |
Дата | |
Msg-id | BLEJJCIDDLINMPGGCKFCAEHFCDAA.hth@sprintsoft.de обсуждение исходный текст |
Ответы |
Re: views with parameters
|
Список | pgsql-novice |
Hi there, i have read http://archives.postgresql.org/pgsql-novice/2001-07/msg00098.php which dates back to july 2001. Has pg developed any further -.. ? i am trying to makes a project compatible for both ms sgl-server and postgresql by using stored procedures (ms) and views (pg) or functions. Much to my dismay the documentation does not specify any parameters/arguments which can be used with views. But views do retun a complete record or record sets as defined in pg. One can send arguments with functions, but by whatever reason (and return type), i have not been able to get anything back which compares to what comes back from an ordinary select oder view. Best i got: a colon separated string having all the data in one field (although a special type was referenced etc.) Is this the way it is .. or did i miss something. i thought i was looking for something simple. thanks in advance for every meaningful response, even if it breaks all my dreams (but saves time). Tom Hermann hth (at) sprintsoft (dot) de
В списке pgsql-novice по дате отправления: