Re: FR and Pgsql - null acctstoptime

Paul, SELECT * FROM radacct WHERE acctstoptime IS NULL; On Wed, 16 Nov 2005 14:45:21 -0500 Paul Khavkine <paul.khavkine@distributel.ca> wrote:

(...) When a Start record gets written to radacct table, AcctStopTime is not being set to anything. The field is empty. Since AcctStopTime is of type "timestamp with time zone" it does not seem to equal to NULL or '0' or anything at all. (...) How do you buidl a query to fetch a list of sessions without AcctStopTime (sessions in progress for example) ?

-- Humberto Diógenes Diginet Brasil -- Esta mensagem foi verificada pelo sistema de anti-virus e acredita-se estar livre de perigo.