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