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!