views with parameters

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

Responses

Browse pgsql-novice by date

  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"