Re: delayed input - Mailing list pgsql-general

From Richard Huxton
Subject Re: delayed input
Date
Msg-id 417543C5.5090903@archonet.com
Whole thread Raw
In response to delayed input  ("Hicham G. Elmongui" <elmongui@cs.purdue.edu>)
List pgsql-general
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 do this functionality using table functions?

Could you not just use a cursor and fetch each row in turn based on some
timer in your application?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Kevin Barnard
Date:
Subject: Re: delayed input
Next
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: delayed input