Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Problem with log data

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 12-03-2009
Member
 
Join Date: Dec 2008
Posts: 94
Problem with log data
  

I logged in an annex to the success of testicular function, including a Time Stamps. As the distance of two records with information
on the cycle time of the plant output, I would like to identify. incl. standard deviation, etc.

I want every record of his predecessor (if possible) identified and the difference in time from the time stamps, and on the basis of this, build a report. The timestamp is unique, ie. so it should go, but I do not know how? The database is PostgreSQL.

Reply With Quote
  #2  
Old 12-03-2009
Member
 
Join Date: May 2008
Posts: 2,290
Re: Problem with log data

Give the table sorted by date, and iterate with a script about it. This is the most elegant way, for all the difference to identify.
Reply With Quote
  #3  
Old 12-03-2009
Member
 
Join Date: Oct 2005
Posts: 2,389
Re: Problem with log data

Does not contain SQL procedural-imperative constructs. No, for other than PostgreSQL DBMS not. No, not at times Orrible. Therefore, most DBMS procedural extensions (PL / SQL at Orrible, PL / PgSQL to PostgreSQL, MS TransactSQL SQL Server, etc.).
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Problem with log data"
Thread Thread Starter Forum Replies Last Post
Problem while inserting data in MS Access Cheng-Gong Windows Software 6 28-02-2011 07:27 PM
Problem with iOS 4 No 3G Data Its_Shaili Portable Devices 5 09-07-2010 03:25 AM
Problem recovering important data Logan 2 Operating Systems 5 06-01-2010 09:05 AM
Problem with Corrupt Data Chintam Portable Devices 7 10-11-2009 02:09 PM
Cloning CD's data problem $tatic Hardware Peripherals 3 29-11-2008 12:05 PM


All times are GMT +5.5. The time now is 11:12 AM.