Re: views with parameters

Sean, I see the point.
Thank you
Tom Hermann

-----Ursprungliche Nachricht-----
Von: Sean Davis [mailto:sdavis2@mail.nih.gov]
Gesendet: Dienstag, 30. November 2004 16:50
An: Thomas Hermann(Software)
Cc: Bruno Wolff III; pgsql-novice@postgresql.org
Betreff: Re: [NOVICE] views with parameters



On Nov 30, 2004, at 4:31 AM, Thomas Hermann(Software) wrote:

> Bruno, thank you for your patience, but I still don't have a clou.
> Let me illustrate this with a sample from MS SQL-Server:
>
> CREATE PROCEDURE au_info_selpub
>    @pubname varchar(40)
> AS
> SELECT au_lname, au_fname, title, pub_name
>    FROM authors a INNER JOIN titleauthor ta
>       ON a.au_id = ta.au_id INNER JOIN titles t
>       ON t.title_id = ta.title_id INNER JOIN publishers p
>       ON t.pub_id = p.pub_id
>    WHERE  p.pub_name = @pubname
>
> EXEC au_info_selpub 'Algodata Infosystems'
>

Why not:

create view au_info_selpub AS SELECT au_lname, au_fname,title,pub_name
      FROM authors a INNER JOIN titleauthor ta
       ON a.au_id = ta.au_id INNER JOIN titles t
       ON t.title_id = ta.title_id INNER JOIN publishers p
       ON t.pub_id = p.pub_id;

Then:

select * from au_info_selfpub where pub_name='Algodata Infosystems';

Sean