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
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
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
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
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
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 tuples
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
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