views with parameters - Mailing list pgsql-novice

From Thomas Hermann(Software)
Subject views with parameters
Date
Msg-id BLEJJCIDDLINMPGGCKFCAEHFCDAA.hth@sprintsoft.de
Whole thread Raw
Responses Re: views with parameters  (Bruno Wolff III <bruno@wolff.to>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"
Next
From: Michael Guerin
Date:
Subject: Re: ERROR: duplicate key violates unique constraint "pg_type_typname_nsp_index"