Method Question

Поиск
Список
Период
Сортировка
От Ben Burkhart
Тема Method Question
Дата
Msg-id 60182.65.31.25.1.1075266487.squirrel@webmail.mudportal.com
обсуждение исходный текст
Ответы Re: Method Question  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: Method Question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
I'm making a layout for a timecard, if a user could clock in/out just once
per day, it wouldn't be a problem, but I need to assume no limits, I
currently have it setup


CREATE TABLE timecard ('id' SERIAL,'employee' varchar(100),'time'
timestamp, inorout varchar(5));

 id | emp  |        time         | outorin
----+------+---------------------+---------
  4 | 9826 | 2004-01-27 06:08:52 | i
  5 | 9826 | 2004-01-27 06:19:54 | o
  6 | 9826 | 2004-01-27 06:20:05 | i
  7 | 9826 | 2004-01-27 08:15:13 | o


Using that as example of the data, how could I tell how many hours have
been in between each i and o? This question stumpeth me. Please help.


В списке pgsql-novice по дате отправления:

Предыдущее
От: nick.tew@budgens.co.uk (Nick Tew)
Дата:
Сообщение: Emailing a list of users when a record is entered in the database.
Следующее
От: "Pragati Kenkare"
Дата:
Сообщение: 'select nextval('seq_name');' in a function ?