Re: storED procedures

Of course!!!!!!! What a stupid question I just made! Sorry.....

The only thing is that view don't implement views don't implement
unions, but I can do union of views instead.

Thanks again!!

Roger Wernersson wrote:

> But views do take "parameters".CREATE VIEW a_view ASSELECT a, MAX(*)
> AS b_maxFROM a_tableGROUP BY b;SELECT b_maxFROM a_viewWHERE 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]
> > 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
>
>
>
--
Nelio Alves Pereira Filho
IFX Networks
Sao Paulo / Brazil