From: | "Thomas Hermann(Software)" <hth(at)sprintsoft(dot)de> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | views with parameters |
Date: | 2004-11-27 20:07:03 |
Message-ID: | BLEJJCIDDLINMPGGCKFCAEHFCDAA.hth@sprintsoft.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Guerin | 2004-11-27 20:25:37 | Re: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index" |
Previous Message | Tom Lane | 2004-11-27 19:06:07 | Re: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index" |