In 7.1.3, you can create a column as "time without time zone", but it
doesn't seem to show as such in psql...
eg:
test=# alter table chat_meetings add column timeofday time without time
zone;
ALTER
test=# \d chat_meetings Table "chat_meetings"Attribute | Type
| Modifier
------------+------------------------+--------------------------------------
------
--------------------meeting_id | integer | not null default
nextval('chat_meetings_mee
ting_id_seq'::text)host_id | integer | not nulltitle | character varying(255) | not nullabstract
| text | not nulltime | integer | not nulldayofweek | smallint
|timeofday | time |
Indices: chat_meetings_pkey, host_id_chat_meetings_key
There's no easy way of seeing what exact type the column is it seems.
Chris