Postgres storing time in strange manner

From: Casey Allen Shobe <cshobe(at)secureworks(dot)net>
To: pgsql-bugs(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Postgres storing time in strange manner
Date: 2002-09-15 07:57:42
Message-ID: 200209150357.42583.cshobe@secureworks.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-novice

I don't have a clue why it's doing this - has anyone else seen this sort of
behavior, or know why it might be doing it? It shows times wrong, for
instance, it shows 00:04:60 where it should show 00:05:00. See below:

gabrielle=# select * from scheduled_query_groups;
group_id | group_name | group_type_id | interval | run_at |
last_run | exec_upon_completion
----------+------------+---------------+----------+-------------+------------
------------+---------------------- 2 | test | 1 | 00:04:60

| 00:00:00-05 | 0001-01-01 04:59:60.00 |

(1 row)

gabrielle=# \d scheduled_query_groups;
Table "scheduled_query_groups"
Column | Type |
Modifiers
----------------------+--------------------------+---------------------------
------------------------------- group_id | integer

| not null default

nextval('sq_groups_group_id_seq'::text)
group_name | character varying(32) | not null
group_type_id | integer | not null
interval | interval | not null default '5
minutes'
run_at | time with time zone | not null default '00:00:00
EST'
last_run | timestamp with time zone | not null default
'0001-01-01 00:00:00 EST'
exec_upon_completion | character varying(128) |
Primary key: scheduled_query_groups_pkey
Unique keys: scheduled_query__group_name_key
Triggers: RI_ConstraintTrigger_16607

--
Casey Allen Shobe / Network Security Analyst & PHP Developer
SecureWorks, Inc. / 404.327.6339 x169 / Fax: 404.728.0144
cshobe(at)secureworks(dot)net / http://www.secureworks.net
Content is my own and does not necessarily represent my company.

Lost Terminal.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Casey Allen Shobe 2002-09-15 12:17:18 Referencing a superselect's column by it's declared alias from a subselect fails
Previous Message David Wheeler 2002-09-15 05:45:45 7.3b1 on Mac OS X (Darwin)

Browse pgsql-novice by date

  From Date Subject
Next Message Casey Allen Shobe 2002-09-15 10:14:33 Referencing system relations?
Previous Message James F. Martin 2002-09-15 03:21:53 WAL file size too big