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 по дате отправления: