Re: delayed input - Mailing list pgsql-general

From Hicham G. Elmongui
Subject Re: delayed input
Date
Msg-id cl3nal$3p0$1@news.hub.org
Whole thread Raw
In response to delayed input  ("Hicham G. Elmongui" <elmongui@cs.purdue.edu>)
Responses Re: delayed input  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: delayed input  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-general
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" <elmongui@cs.purdue.edu> wrote in message
news:cl3eaj$1ggv$1@news.hub.org...
> 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 using table functions?
>
> Regards,
> --h
>
>



pgsql-general by date:

Previous
From: "Gary Doades"
Date:
Subject: Re: removing idle connections
Next
From: Alvaro Herrera
Date:
Subject: Re: delayed input