Re: Very slow stored proc

On Thu, Dec 23, 2004 at 09:48:56PM +0100, Együd Csaba (Freemail) wrote:

Hi,

> Dear Alvarao,

Wow, now that's a strange misspelling.  I've seen several but this one
is new to me :-D

> would you please so kind explaining me your opinion in details.

What do you want that table for?  If you are using it as input for a
query, it's possible that you can forget about refilling it every now
and then, and instead using a set-returning function (SRF) in the FROM
clause of said query.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"I dream about dreams about dreams", sang the nightingale
under the pale moon (Sandman)