Date difference in seconds - Mailing list pgsql-general

Hi ,
         Please consider the following schema and the query given below and
let me know how to get the results I want.

CREATE TABLE  temp (
       id                   INTEGER  NOT NULL,
       start_time       TIMESTAMP,
       end_time        TIMESTAMP,
       PRIMARY KEY (id)
);

Now I want the difference between start time and end time in seconds.
        Select date_part('seconds',start_time - end_time) from temp;  gives
me only the difference between the seconds value in both timestamps. It
ignores all the days, hrs, minutes etc.

My problem is that I want the actual difference between the two timestamps
expressed in seconds.

Please advice me how to write the SQL Query.

With Regards,
Raghunath T
Senior Software Engg,
MindTree Consulting Private Ltd,
Santa Clara, CA, USA