views with parameters

Поиск
Список
Период
Сортировка
От Thomas Hermann(Software)
Тема views with parameters
Дата
Msg-id BLEJJCIDDLINMPGGCKFCAEHFCDAA.hth@sprintsoft.de
обсуждение исходный текст
Ответы Re: views with parameters  (Bruno Wolff III <bruno@wolff.to>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"
Следующее
От: Michael Guerin
Дата:
Сообщение: Re: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"