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 do this functionality using table functions?
>
> Regards,
> --h
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>