Re: storage procedures

But 'views' don't receive parameters, they're just 'static' queries. I'd like
to pass some parameters and then receive the result table.

I'm developping a web base application, and if stored procedures increase
performance, I 'd like to use them to retrieve some data.

Nelio

Roger Wernersson wrote:

> "2" would be a view.
>
> A view can calculate almost any value for any column for any number of rows.
>
> IMHO
>
> /Roger
>
> -----Original Message-----
> From: Nelio Alves Pereira Filho [mailto:nelio(at)ifx(dot)com(dot)br]
> Sent: Thursday, November 09, 2000 6:53 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] storage procedures
>
> I have two questions:
>
> 1) How faster are storage procedures from normal queries?
> 2) Can I define a storage procedure that returns a table? Like,
> "SELECT * FROM table"
>
> Thanks
>
> Nelio Pereira
> IFX Networks
> Brazil

--
Nelio Alves Pereira Filho
IFX Networks
Sao Paulo / Brazil