RE: storage procedures

But views do take "parameters".

CREATE VIEW a_view AS
SELECT a, MAX(*) AS b_max
FROM a_table
GROUP BY b;

SELECT b_max
FROM a_view
WHERE a = 'hello'; /* parameter */

I don't know what problem you want to solve but if you give me an example I
will try to show you what I mean.

/Roger

-----Original Message-----
From: Nelio Alves Pereira Filho [mailto:nelio(at)ifx(dot)com(dot)br]
Sent: Thursday, November 09, 2000 8:53 PM
To: Roger Wernersson
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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
<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