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 null
title | character varying(255) | not null
abstract | text | not null
time | integer | not null
dayofweek | 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
