Results 1 to 3 of 3

Thread: Problem with log data

  1. #1
    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.

  2. #2
    Join Date
    May 2008
    Posts
    2,302

    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.

  3. #3
    Join Date
    Oct 2005
    Posts
    2,394

    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.).

Similar Threads

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •