Well, it seems that i have to build the scan operator myself. Even the
FunctionScan will make all the function calls and stores the result in a
tuuplestore. So, all the delay will be occured only at the first function
invocation.
--h
"Alvaro Herrera" <[EMAIL PROTECTED]> wrote in message
news:[E
Hicham G. Elmongui wrote:
I need this for a side project. Is there a way to do something like this:
SELECT *
FROM DelayedTable('tablename', 5);
No, at my knowledge you'll obtain the first tuple only when
the function exit.
Regards
Gaetano Mendola
---(end of broadcast)--
On Tue, Oct 19, 2004 at 01:44:34PM -0500, Hicham G. Elmongui wrote:
> I need this for a side project. Is there a way to do something like this:
>
> SELECT *
> FROM DelayedTable('tablename', 5);
You can probably build a sleep() function in C, and then use that to
cause delaying in a PL/pgSQL set-r
I need this for a side project. Is there a way to do something like this:
SELECT *
FROM DelayedTable('tablename', 5);
DelayedTable provides me with one tuple every 5 seconds.
Regards,
--h
"Hicham G. Elmongui" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I need to select all tupl
Use a cursor...
I need to select all tuples from a table, but need them to be fetched
with a
constant delay (say 1 sec) between every consecutive tuples.
The first idea that came up to my mind is to create a DelayedSeqScan
operator, and put delay before returning the scanned tuple.
Can
Hicham G. Elmongui wrote:
I need to select all tuples from a table, but need them to be fetched with a
constant delay (say 1 sec) between every consecutive tuples.
The first idea that came up to my mind is to create a DelayedSeqScan
operator, and put delay before returning the scanned tuple.
Can I
Why not do this on the client side? I'm just curious as to the benfit
of doing this on the server.
On Tue, 19 Oct 2004 11:10:58 -0500, Hicham G. Elmongui
<[EMAIL PROTECTED]> wrote:
> I need to select all tuples from a table, but need them to be fetched with a
> constant delay (say 1 sec) between
I need to select all tuples from a table, but need them to be fetched with a
constant delay (say 1 sec) between every consecutive tuples.
The first idea that came up to my mind is to create a DelayedSeqScan
operator, and put delay before returning the scanned tuple.
Can I do this functionality us
