Well, it seems that i have to build the scan operator myself. Even the FunctionScan will make all the function calls and stores the result in a tuuplestore. So, all the delay will be occured only at the first function invocation. --h
"Alvaro Herrera" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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) > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
