Re: [SQL] Updating session id based on accesstimeout

2003-12-02 Thread greg
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I want to set a session id based on a session timeout per user. I > have a very large logfile with more than 1.3 Mio records and look > for a very efficient solution - maybe with PL/pgSQL . Can you post a clearer example with the exact columns

Re: [SQL] Updating session id based on accesstimeout

2003-11-29 Thread Jamie Lawrence
On Sat, 29 Nov 2003, Andreas Heissenberger wrote: > Hi, > > I want to set a session id based on a session timeout per user. I have a very large > logfile with more than 1.3 Mio records and look for a very efficient solution - > maybe with PL/pgSQL . > > The important columns in the table are:

[SQL] Updating session id based on accesstimeout

2003-11-29 Thread Andreas Heissenberger
Hi,   I want to set a session id based on a session timeout per user. I have a very large logfile with more than 1.3 Mio records and look for a very efficient solution - maybe with PL/pgSQL .   The important columns in the table are: access timestamp and userid sorted by userid and access t