RE: storage procedures - Mailing list pgsql-general

From Roger Wernersson
Subject RE: storage procedures
Date
Msg-id 5146853DD571D411AC54000102070D6101256C@MINGBGNTS02
Whole thread Raw
In response to storage procedures  (Nelio Alves Pereira Filho <nelio@ifx.com.br>)
List pgsql-general
"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@ifx.com.br]
Sent: Thursday, November 09, 2000 6:53 PM
To: pgsql-general@postgresql.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

pgsql-general by date:

Previous
From: Jeff Eckermann
Date:
Subject: RE: Appending null produces null? AND RE: [GENERAL] NVL (sql oracle)
Next
From: Nelio Alves Pereira Filho
Date:
Subject: Re: storage procedures