RE: [SQL] Mail for error in tuples

It might be best if you gave us an actual example or two in stead of trying
to describe the situation (I couldn't follow it, I have no idea what a
radius log is either).  So, show us what you're after.-DEJ

> -----Original Message-----
> From:    Vikrant Rathore [SMTP:vikrant@chemquick.com]
> Sent:    Friday, June 11, 1999 1:45 PM
> To:    pgsql-sql@postgreSQL.org
> Subject:    [SQL] Mail for error in tuples
> 
> Dear friend,
> 
>     I have a table named radius with structure
> 
> Table    = radius
> +----------------------------------+----------------------------------+---
> ----+
> 
> |              Field               |              Type                |
> Length|
> +----------------------------------+----------------------------------+---
> ----+
> 
> | uname                            | char()
> |   256 |
> | logdate                          | date
> |     4 |
> | logtime                          | time
> |     8 |
> | duration                         | timespan
> |    12 |
> | status                           | char()
> |    20 |
> | nasadd                           | char()
> |    20 |
> | port                             | int4
> |     4 |
> | bytesin                          | int4
> |     4 |
> | bytesout                         | int4
> |     4 |
> | packin                           | int4
> |     4 |
> | packout                          | int4
> |     4 |
> | misc                             | int4
> |     4 |
> +----------------------------------+----------------------------------+---
> ----+
> 
> I keep my radius log in this table.
> 
> Now in this logdate and logtime are the last logout date and time for
> the particular user.
> 
> But sometimes the logdate and logtime and duration are wrong so inorder
> to correct i have to do following can anyone help me how to do it.
> 
> I want to select the tuples of particular user and test the first
> logdate and logtime with the next tuples logdate and logtime and the
> duration in the second tuple should not be greater than the difference
> of this two tuples if its greater than the difference then it needs to
> be set to the difference of the two logdate and logtime. I have to test
> it till the last tuple.
> So can anyone suggest me query for this job.
> 
> Thanks in advance.
> 
> Regards,
> Vicky
> 
>