Re: views with parameters - Mailing list pgsql-novice

From Thomas Hermann(Software)
Subject Re: views with parameters
Date
Msg-id BLEJJCIDDLINMPGGCKFCOEHMCDAA.hth@sprintsoft.de
Whole thread Raw
In response to views with parameters  ("Thomas Hermann(Software)" <hth@sprintsoft.de>)
List pgsql-novice
Tom, this last message finally turned me into the right direction
thank you once again
Tom Hermann

-----Ursprüngliche Nachricht-----
Von: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Gesendet: Dienstag, 30. November 2004 19:05
An: Thomas Hermann(Software)
Betreff: Re: AW: [NOVICE] views with parameters


> My experience with the function although (in 8.0 beta) is,
> that it returns not the same data a the view would return.
> It returns a comma separated text string, although the requested data is
> presented.

There's a difference between "select foo()" and "select * from foo()".
The first returns a single composite column.

            regards, tom lane


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Data directory copies...
Next
From: Tom Lane
Date:
Subject: Re: catch runtime errors