Re: delayed input

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 set-returning function.  Something like

#include <postgres.h>
#include <fmgr.h>

PG_FUNCTION_INFO_V1(sleep);

Datum
sleep(PG_FUNCTION_ARGS)
{
    int32   delay = PG_GETARG_INT32(0);
    sleep(delay);
    PG_RETURN_VOID();
}

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
La web junta la gente porque no importa que clase de mutante sexual seas,
tienes millones de posibles parejas. Pon "buscar gente que tengan sexo con
ciervos incendiándose", y el computador dirá "especifique el tipo de ciervo"
(Jason Alexander)