[Pgsql-ayuda] Problema en función al usar "timestamp + interval '$1 seconds' "

[Alvaro Herrera]

On Tue, Oct 21, 2003 at 10:36:51AM -0300, Sebastián Villalba wrote:

> create or replace function checktimeout(char, integer) returns integer as '
>    update conexiones
>    set sessionFinish = now()
>    where sessionId like $1
>    and sessionLastAction + interval '$2 seconds' < now();

    and sessionLastAction + $2 * '1 second'::interval < now();

> select 1;
> ' language sql;

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Hi! I'm a .signature virus!
cp me into your .signature file to help me spread!